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' )
What is the highest salary? who did earn it
select * from employees order by salary desc limit 1
What is the lowest salary? who did earn it
select * from employees order by salary limit 1
What is the name of the following phone number 515.123.4569? Tell me Employer ID
select employee_id, first_name, last_name from employees where phone_number = "515.123.4569"
What is the lowest hire date? tell me the first name.
select first_name, hire_date from employees order by hire_date limit 1