Great, could you tell me the name and number of employees within those departments?
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'
Awesome, could you show me the budget of those departments?
select budget_in_billions from department as t1 join management as t2 on t1.department_id = t2.department_id where t2.temporary_acting = 'Yes'
Could you tell me when those departments were founded, and display the name next to each founding year?
select creation, name from department as t1 join management as t2 on t1.department_id = t2.department_id where t2.temporary_acting = 'Yes'
Could you tell me how many departments have a head whose temporary acting value is 'no'?
select count ( * ) from management where temporary_acting = 'No'