SELECT Creation, AVG(Budget_in_Billions) FROM department GROUP BY Creation ORDER BY Creation DESC
Plot the average of budget in billions over creation in a line chart, I want to sort in desc by the Creation.
CREATE TABLE head (
    head_ID int,
    name text,
    born_state text,
    age real
)

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
)