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)
CREATE TABLE head (head_ID NUMBER, name CLOB, born_state CLOB, age FLOAT)

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