- 2
Write a SQL query to return the top 5 customer names based on the $ amount ordered
assume you have a customer and orders table where a customer can have many tables. assume that the tables have reasonable columns like customerName, customerID, orderCost, etc. I'm pretty new to sql any help is appreciated
1 Answer
+ 1
SELECT FirstName FROM employees
ORDER BY customerorder DESC
LIMIT BY 5;