CREATE TABLE management (department_ID NUMBER, head_ID NUMBER, temporary_acting CLOB)
CREATE TABLE head (head_ID NUMBER, name CLOB, born_state CLOB, age FLOAT)
CREATE TABLE department (Department_ID NUMBER, Name CLOB, Creation CLOB, Ranking NUMBER, Budget_in_Billions FLOAT, Num_Employees FLOAT)

Show the name and number of employees for the departments managed by heads whose temporary acting value is 'Yes'. Show the proportion.
SELECT Name, SUM(Num_Employees) FROM department AS T1 JOIN management AS T2 ON T1.department_ID = T2.department_ID WHERE T2.temporary_acting = 'Yes' GROUP BY Name
SELECT "Name", SUM("Num_Employees") FROM "department" "T1" JOIN "management" "T2" ON "T1"."department_ID" = "T2"."department_ID" AND "T2"."temporary_acting" = 'Yes' GROUP BY "Name"