Top 10 Customers by Spend

EarthCam wants to identify the customers generating the most revenue from camera, monitoring, and streaming orders. Write a PostgreSQL query that returns the 10 customers with the highest total spend.

Requirements

1. Group order records by customer_name and calculate total spend with SUM(amount).
2. Ignore orders with a NULL amount. A customer whose orders all have a NULL amount has no measurable spend and must not appear in the result.
3. Return the top 10 customers, ordered by total spend from highest to lowest. Use customer_name ascending as a deterministic tie-breaker. If fewer than 10 customers have spend, return all of them.
4. Return the columns customer_name and total_spent.