What are the id for the employee whose first name is Payam?
select employee_id from employees where first_name = 'Payam'
Which employees' manager is him?
select * from employees where manager_id = (select employee_id from employees where first_name = 'Payam' )
What are their ids and salaries?
select employee_id, salary from employees where manager_id = (select employee_id from employees where first_name = 'Payam' )