Relationships and Schema

select *
from employee join department on employee.department = department.id
where dept_name='Sales'


select emp_name
from employee_project join project on employee_project.project_id = project.id join employee on emp_id = employee.id
where project_name='Plan christmas party'


select *
from employee join department on employee.department = department.id join employee_project on employee.id = employee_project.emp_id join project on employee_project.project_id = project.id
where project_name ='Watch paint dry' and dept_name ='Warehouse'


select project_name
from employee_project join project on employee_project.project_id = project.id join employee on emp_id = employee.id join department on employee.department = department.id
where dept_name ='Sales'


select emp_name
from department join employee on department.manager = employee.id join employee_project on employee_project.emp_id = employee.id join project on employee_project.project_id = project.id
where project_name ='Watch paint dry'