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.
CREATE TABLE management (
    department_ID int,
    head_ID int,
    temporary_acting text
)

CREATE TABLE department (
    Department_ID int,
    Name text,
    Creation text,
    Ranking int,
    Budget_in_Billions real,
    Num_Employees real
)

CREATE TABLE head (
    head_ID int,
    name text,
    born_state text,
    age real
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE management (
    department_ID int,
    head_ID int,
    temporary_acting text
)

CREATE TABLE department (
    Department_ID int,
    Name text,
    Creation text,
    Ranking int,
    Budget_in_Billions real,
    Num_Employees real
)

CREATE TABLE head (
    head_ID int,
    name text,
    born_state text,
    age real
) ### Response: 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