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)

I want to see trend of the number of creation by creation, could you list in descending by the X?
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