SQL Practice question

Question

The sales department is holding a competition to see who has sold to the most customers. For this request, the manager only needs to see the employee id, last name, and first name for the employee, then a count for how many customers that employee sold to. The manager would like the results sorted by employee id. The data elements must appear in the order they are listed in the request. Given only eight employees in the company and 59 customers, the results should not reflect anything over these checkpoint numbers. 

Answer 1

Since I don't have all the table names listed, I will assume all the data is in the same table called: Sales.

If you have a column that has a total number for each sale you can use the SUM(ColumnName) to add up all the sales per employee. I used the count function since this will count the rows for each employee ID when it separates them using the Group by clause.

Select employeeid, lastname, firstname, Count(*) AS SalesPerEmployee

From Sales

Group by employeeid, lastname, firstname

Order by employeeid