Write a query to extract the top 10 customers based on sales from a database. Use the customer and sales data provided. Include customers with no recorded sales, treating their total as zero.
customer_id, customer_name, and total_sales.total_sales descending.customer_id ascending.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer's full name |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sales transaction identifier |
| customer_id | INT | Customer associated with the sale |
| sales_amount | DECIMAL(12,2) | Monetary value of the sale |