How much is the salary for employee id 163?
select salary from employees where employee_id = 163
What is employee id 163 full name?
select first_name, last_name from employees where employee_id = 163
Show me the full name for the employees that get more salary then employee 163?
select first_name, last_name from employees where salary > ( select salary from employees where employee_id = 163 )
What department does employee 163 work under?
select department_id from employees where employee_id = 163
How many employee's work for employee's 163 department?
select count ( * ) from employees where department_id = ( select department_id from employees where employee_id = 163 )
Who is the head of this department?
select distinct manager_id from employees where department_id = ( select department_id from employees where employee_id = 163 )