SELECT employee_id ,  salary FROM employees WHERE manager_id  =  (SELECT employee_id FROM employees WHERE first_name  =  'Payam' )
display the employee id and salary of all employees who report to Payam (first name).
SELECT employee_id , salary FROM employees WHERE manager_id = ( SELECT employee_id FROM employees WHERE first_name = 'Payam ' )
select employee_id , salary from employees where manager_id = ( select employee_id from employees where first_name = value )
display the employee id and salary of all employees who report to Payam ( first name ) .