List Number of Orders Per Employee
List Number of Orders Per Employee
Orders Table:
Employees Table:
Query Explanation:
-
LEFT JOIN: Includes all employees, even if they have zero orders. -
COUNT(Orders.OrderID): Counts how many orders each employee handled. -
GROUP BY: Groups the result per employee.
SQL Query:
SELECT
Employees.EmployeeID,
Employees.FirstName,
Employees.LastName,
COUNT(Orders.OrderID) AS TotalOrders
FROM Employees
LEFT JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID
GROUP BY Employees.EmployeeID, Employees.FirstName, Employees.LastName;
Output:
