Write a SQL query to find the top five products by sales volume from a sales database.
Use the provided products and sales tables. Sales volume is the total quantity sold for each product. Include products with no matching sales when determining the ranking.
product_name and sales_volume.sales_volume descending, breaking ties by product_id ascending.| 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 referenced by the sale |
| quantity | INT | Number of units sold |
| sold_at | DATE | Date of sale |