human
Schema:
department (Department_ID, Name, Creation, Ranking, Budget_in_Billions, Num_Employees)
head (head_ID, name, born_state, age)
management (department_ID, head_ID, temporary_acting)
Please answer with SQL.
assistant
Sure, I understand.
human
In which year were most departments established?
assistant
SELECT creation FROM department GROUP BY creation ORDER BY COUNT( * ) DESC LIMIT 1;
human
How many different departments were created in 1789?
assistant
SELECT COUNT( * ) FROM department GROUP BY creation ORDER BY COUNT( * ) DESC LIMIT 1;
human
What are the names of those two departments?
assistant
SELECT name FROM department GROUP BY creation ORDER BY COUNT( * ) DESC LIMIT 1;
human
How many employees does the Treasury Department have?
assistant
SELECT Num_Employees FROM department WHERE name = "Treasury" ;