Write a SQL query to find the top-performing products by revenue using ranking.
Use the provided product and order item data. Return the top three ranking positions, including all products tied at the third position.
product_id, product_name, total_revenue, and revenue_rankrevenue_rank ascending, then product_id ascending| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product display name |
| category | VARCHAR(60) | Product category |
| Column | Type | Description |
|---|---|---|
| order_item_idPK | INT | Unique order item identifier |
| product_id | INT | Referenced product identifier |
| quantity | INT | Units sold in the order item |
| unit_price | DECIMAL(10,2) | Selling price per unit |