𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: You have 2 minutes to solve this SQL query.

List employees who earn more than their department manager's salary from the employees table (manager_id references employee id).

𝗠𝗲: Challenge accepted!

SELECT e1.name, e1.department, e1.salary
FROM employees e1
JOIN employees e2 ON e1.department = e2.department AND e1.manager_id = e2.id
WHERE e1.salary > e2.salary;

I self-joined the employees table on department and manager_id to compare each employee's salary against their manager's in the same department. The WHERE clause filters for employees earning more. This tests join mastery for hierarchical data, common in org charts.

𝗧𝗶𝗽 𝗳𝗼𝗿 𝗦𝗤𝗟 𝗝𝗼𝗯 𝗦𝗲𝗲𝗸𝗲𝗿𝘀:
Self-joins shine for intra-table relationships like managers/employees or siblings—practice with employee hierarchies to impress in data engineering interviews!

React with ❤️ for more