Write a SQL query to find the top three highest-grossing products from a sales table.
Calculate gross revenue as quantity multiplied by unit price. Use the product details associated with each sale.
product_id, product_name, and total_revenuetotal_revenue descendingproduct_id ascending| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product display name |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| product_id | INT | Product associated with the sale |
| quantity | INT | Number of units sold |
| unit_price | NUMERIC(10,2) | Price per unit at the time of sale |