relationships-practice

relationships-practice

How many people work in the Sales department? - 4 - 
SELECT
  e.emp_name as Full_Name,
  e.salary as Salary,
  d.dept_name as Department
FROM
  employee e
  INNER JOIN
  department d
  ON e.department = d.id
WHERE
  d.dept_name = 'Sales';
List the names of all employees assigned to the 'Plan Christmas party' project. - Toby Flenderson
List the names of employees from the Warehouse department that are assigned to the 'Watch paint dry' project. - n/a
Which projects are the Sales department employees assigned to? - watch paint dry
List only the managers that are assigned to the 'Watch paint dry' project.- Jim halpert