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

How many departments are built in each year? Group by creation time in a line chart, and rank x axis from high to low order.
SELECT Creation, COUNT(Creation) FROM department GROUP BY Creation ORDER BY Creation DESC
SELECT "Creation", COUNT("Creation") FROM "department" GROUP BY "Creation" ORDER BY "Creation" DESC