Write a SQL query to return the top 5 customer names based on the $ amount ordered

Question

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

Answer 1

SELECT FirstName FROM employees

ORDER BY customerorder DESC
LIMIT BY 5;