human
Schema:
department (Department_ID, Name, Creation, Ranking, Budget_in_Billions, Num_Employees)
head (head_ID, name, born_state, age)
management (department_ID, head_ID, temporary_acting)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the departments managed by heads whose temporary acting value is 'yes'? | The following table shows the names of departments managed by heads whose temporary acting value is 'yes'. | Show me the name and number of employees for the Treasury department.
assistant
SELECT name , num_employees FROM department WHERE name = "Treasury" ;