Show the names and number of employees of each department.
select name, num_employees from department
Who are the department heads whose temporary acting value is "Yes"?
select * from management where temporary_acting = 'Yes'
Show the name and number of employees for the departments managed by heads whose temporary acting value is 'Yes'.
select t1.name, t1.num_employees from department as t1 join management as t2 on t1.department_id = t2.department_id where t2.temporary_acting = 'Yes'