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

Show the name and number of employees for the departments managed by heads whose temporary acting value is 'Yes' Visualize by bar chart, rank bar in descending order.
SELECT Name, AVG(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 ORDER BY Name DESC
SELECT "Name", AVG("Num_Employees") FROM "department" "T1" JOIN "management" "T2" ON "T1"."department_ID" = "T2"."department_ID" AND "T2"."temporary_acting" = 'Yes' GROUP BY "Name" ORDER BY "Name" DESC