Question

List the total number of cars sold by each employee.

Answer 1

SELECT EmpId, COUNT(*) AS Total_Cars_Sold
FROM SALE
GROUP BY EmpId;