Problem

Given a table of employee data, write a stored procedure that returns the total number of employees in each department.
Example input:
| Department |
|------------|
| Sales      |
| Marketing  |
| IT         |
Example output:
| Department | Total Employees |
|------------|-----------------|
| Sales      | 10              |
| Marketing  | 5               |
| IT         | 3               |

Solution

/*

Solution:

SELECT Department, COUNT(*) AS TotalEmployees
FROM Employee
GROUP BY Department

This solution is optimal because it uses the GROUP BY clause to group the employees by department, and then uses the COUNT() function to count the number of employees in each department.

*/