Find employees who are earning more than their managers. Output the employee's first name along with the corresponding salary.
table name: employee
Solution:
select e.first_name,e.salary,m.salary from employee as e
join employee as m on e.manager_id = m.id
where e.salary > m.salary
Output: