How would you write a SQL query to identify the top-performing Goodyear product categories across different sales regions?
Use the Goodyear sales data for completed transactions in calendar year 2025. Return the highest-revenue category or categories within each region, preserving ties.
Output
- One row per top-performing category and region.
- Columns:
region_name, category_name, total_revenue, and category_rank.
- Include only regions with qualifying sales, ordered by region, rank, and category name.
