CREATE TABLE management (department_ID INT, head_ID INT, temporary_acting TEXT)
CREATE TABLE department (Department_ID INT, Name TEXT, Creation TEXT, Ranking INT, Budget_in_Billions FLOAT, Num_Employees FLOAT)
CREATE TABLE head (head_ID INT, name TEXT, born_state TEXT, 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"