Can you write SQL queries to find the top 10 sales from a sales database?
Use the provided sales, customers, and products tables. Include completed sales with non-null amounts and matching customer and product records.
sale_id, sale_date, customer_name, product_name, and sale_amount.sale_amount descending, with sale_id ascending as the tie-breaker.| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| customer_id | INT | Customer associated with the sale |
| product_id | INT | Product included in the sale |
| sale_date | DATE | Date the sale occurred |
| amount | DECIMAL(12,2) | Total monetary value of the sale |
| status | VARCHAR(20) | Sale processing status |
| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product display name |