Question

Q21: You are asked to find out the top sales representative (by the accumulated dollar amount of orders) in Northwind. Write a SQL command to return the LastName, FirstName and the total dollar amount of orders of that employee under the column Total with a dollar sign ($) as prefix. (1 mark)

Answer 1

Since you have not provided the schema details, I am guessing the table and column names and providing you the query. Hence, these queries might need some modification. Reach out to me via the comment section in case you need help.

The query is:

SELECT LastName, FirstName, concat('$', , sum(OrderAmount)) AS Total FROM EMPLOYEE WHERE City = 'Northwind' GROUP BY EmployeeId ORDER BY sum(OrderAmount) DESC LIMIT 1;