November 4 Answers - ndgriffeth/Class-Notes-and-Lectures GitHub Wiki

List all male employees.

select * from employees where gender="M";

List employees born on 9/2/1953.

Select * from employees where employees.birth_date="1953-09-02";

List employees born after 9/2/1953.

Select * from employees where employees.birth_date>"1953-09-02";

List employees making more than 100,000.

Select e.emp_no, s.salary 
from employees e, salaries s
where e.emp_no=s.emp_no and 
      s.salary>100000;

Find the manager of Margareta Markovitch.

select  m.emp_no, m.last_name 
from employees m, employees e, dept_emp de, dept_manager dm
where m.emp_no=dm.emp_no and
      e.emp_no=de.emp_no and
      dm.dept_no=de.dept_no and
      e.first_name="Margareta" and
      e.last_name="Markovitch";

List the employees that are currently working for manager Margareta Markovitch.

Select e.emp_no, m.emp_no, e.first_name, e.last_name 
from employees e, employees m, dept_manager dm, dept_emp de 
where m.emp_no=dm.emp_no and 
      e.emp_no=de.emp_no and 
      de.dept_no=dm.dept_no and 
      m.first_name="Margareta" and 
      m.last_name="Markovitch" and ...