Given a dataset of employees and managers, write a query to fetch all employees who earn more than their managers.

Assuming a table employees with columns emp_id, manager_id, and salary, you can use a self‑join or a correlated subquery. Here’s a concise solution with a self‑join: ``sql SELECT e.emp_id, e.name, e.salary, m.name AS manager_name, m.salary AS manager_salary FROM employees e JOIN employees m ON e.manager_id = m.emp_id WHERE e.salary > m.salary; `` This returns each employee whose salary exceeds that of their direct manager. If you need to consider indirect managers, replace the join with a recursive CTE that walks up the hierarchy before comparing salaries.