Find the first name and last name and department id for those employees who earn such amount of salary which is the smallest salary of any of the departments.
select first_name, last_name, department_id from employees where salary in ( select min ( salary ) from employees group by department_id )
Which of those has the highest salary?
select first_name, last_name, department_id from employees where salary in ( select max ( salary ) from employees group by department_id )
yes
select first_name,last_name from employees order by salary desc limit 1
Give me the name and salary of the highest paid employee and their manager
select first_name,last_name,salary,manager_id from employees order by salary desc limit 1