🧠 SQL Interview Question (Moderate–Tricky & Top Performer Analysis)
📌

sales(region, salesperson_id, revenue)

❓ Ques :

👉 Find the top 2 highest revenue-generating salespersons in each region.

🧩 How Interviewers Expect You to Think

• Data is grouped by region 🌍
• Need ranking within each group
• Handle ties carefully (RANK / DENSE_RANK)
• Filter top N per group

💡 SQL Solution

SELECT region, salesperson_id, revenue
FROM (
SELECT
region,
salesperson_id,
revenue,
DENSE_RANK() OVER (PARTITION BY region ORDER BY revenue DESC) AS rnk
FROM sales
) t
WHERE rnk <= 2;

🔥 Why This Question Is Powerful

• Tests window functions (RANK / DENSE_RANK) 🧠
• Very common in business reporting & leaderboards 📊
• Checks understanding of partitioning + ordering logic

❤️ React if you want more such real interview-level SQL questions 🚀