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

I want to see trend of the number of creation by creation
SELECT Creation, COUNT(Creation) FROM department GROUP BY Creation
SELECT "Creation", COUNT("Creation") FROM "department" GROUP BY "Creation"