Write a SQL query to join two tables and calculate total sales by customer at Kpmg Us. Use the provided customers and sales tables.
customer_id, customer_name, and total_sales.total_sales descending, then customer_name ascending to break ties.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer or account name |
| region | VARCHAR(50) | KPMG US operating region |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| customer_id | INT | Customer associated with the sale |
| sale_amount | NUMERIC(12,2) | Sale amount in US dollars |
| sale_date | DATE | Date the sale was recorded |