41. Top 5 Customers Per Region
DENSE_RANK() PARTITION BY Region
42. Top 5 Products Per Region
Same logic.
43. Revenue Rank
RANK() OVER(ORDER BY Revenue DESC)
44. Profit Rank
DENSE_RANK()
45. Monthly KPI Dashboard Query
Typically includes:
- Revenue
- Customers
- Orders
- Growth %
in one query.
46. Revenue vs Target
Actual - Target
47. Revenue Achievement %
Actual/Target*100
48. Top Revenue Quarter
GROUP BY Quarter
49. Revenue Forecast Baseline
Uses:
Moving Average
50. Executive Interview Favorite
Build a Sales Dashboard Dataset
Metrics:
- Total Revenue
- Total Orders
- Total Customers
- Avg Order Value
- MoM Growth
- YoY Growth
- Top Products
- Top Customers
Expected SQL Skills:
✅ Joins
✅ Aggregations
✅ Window Functions
✅ Ranking
✅ Date Functions
✅ Business Logic
Most Asked Business SQL Questions
- Top Customers
- Customer Churn
- CLV (Customer Lifetime Value)
- MoM Growth
- YoY Growth
- Running Total
- Pareto Analysis
- Revenue Contribution %
- Top Products
- Dashboard Dataset Creation
