🔥 SQL Scenario-Based Q&A (Part 3)
Think like a real analyst 👇

📊 Running Total (Cumulative Sum)?

👉 Use SUM() OVER()
👉 PARTITION BY (optional)
👉 ORDER BY for sequence

📊 Top N records per group?

👉 Use ROW_NUMBER() / RANK()
👉 PARTITION BY category
👉 Filter where rank ≤ N

📊 Find duplicate records?

👉 GROUP BY + HAVING COUNT(*) > 1
👉 Or use ROW_NUMBER()
👉 Helps in data cleaning

📊 Delete duplicate rows (keep one)?

👉 Use CTE + ROW_NUMBER()
👉 Delete where row_num > 1
👉 Keep latest/oldest using ORDER BY

📊 Employees earning more than their manager?

👉 Self JOIN on employee table
👉 Compare employee salary > manager salary
👉 Classic interview favorite

🔥 React ♥️ if you want Part 4