Write a SQL query to find the top five products by sales volume.
Use the products and sales tables. Treat a product with no recorded sales as having a sales volume of zero.
product_id, product_name, and sales_volumesales_volume descending, then product_id ascending to break ties| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product name |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| product_id | INT | Product associated with the sale |
| quantity | INT | Number of units sold |
| sale_date | DATE | Date of the sale |