You are given a single sales table from a reporting dataset. Write a PostgreSQL query to return the top 10 customers by total revenue. Revenue should be calculated as the sum of sale_amount for each customer, ignoring rows where sale_amount is NULL. Return the customer name and total revenue, sorted from highest to lowest revenue.
customer_name and total_revenue, in that order.customer_name ascending.customer_name is NULL as a customer group.| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique identifier for each sale |
| customer_name | VARCHAR(100) | Customer name associated with the sale |
| sale_amount | DECIMAL(10,2) | Revenue amount for the sale |
| sale_date | DATE | Date the sale was recorded |