CREATE TABLE head (head_ID INT, name TEXT, born_state TEXT, age FLOAT)
CREATE TABLE department (Department_ID INT, Name TEXT, Creation TEXT, Ranking INT, Budget_in_Billions FLOAT, Num_Employees FLOAT)
CREATE TABLE management (department_ID INT, head_ID INT, temporary_acting TEXT)

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 NULLS LAST