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)
CREATE TABLE management (department_ID NUMBER, head_ID NUMBER, temporary_acting CLOB)

Show the name and number of employees for the departments managed by heads whose temporary acting value is 'Yes' Visualize by bar chart, list from high to low by the Y.
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 AVG(Num_Employees) 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 AVG("Num_Employees") DESC