Whenever you're ready, walk me through how you'd approach this.
Write a SQL query to find the top 3 products by revenue for each region.
The answer should calculate revenue at the product and region level, rank products independently within each region, and address how ties should be handled.