๐ Find employees who earn more than their manager
Table: Employees
Columns:
employee_id, employee_name, manager_id, salary
๐ Query:
SELECT
e.employee_id,
e.employee_name,
e.salary,
m.employee_name AS manager_name,
m.salary AS manager_salary
FROM Employees e
JOIN Employees m
ON e.manager_id = m.employee_id
WHERE e.salary > m.salary;
๐ฏ Why this question matters:
โ Tests Self Joins
โ Evaluates understanding of hierarchical data
โ Commonly asked in SQL interviews and real-world scenarios
๐ Pro Tip:
Whenever a table references itself (employees-managers, users-referrals, categories-parent categories), a Self Join is often the cleanest solution.
๐ฅ React โค๏ธ for more advanced SQL interview questions ๐