Write a SQL query to extract the top 10 performing products.
Use the provided product and sales data. Treat completed sales as valid performance activity and include products without completed sales when determining the ranking.
product_id, product_name, total_revenue, and total_units.total_revenue descending, then product_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product name |
| category | VARCHAR(50) | Product category |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| product_id | INT | Product associated with the sale |
| quantity | INT | Number of units sold |
| sale_amount | DECIMAL(12,2) | Revenue generated by the sale |
| status | VARCHAR(20) | Sale status |