CREATE TABLE department (department_id NUMBER, name CLOB, creation CLOB, ranking NUMBER, budget_in_billions NUMBER, num_employees NUMBER)
CREATE TABLE head (head_id NUMBER, name CLOB, born_state CLOB, age NUMBER)
CREATE TABLE management (department_id NUMBER, head_id NUMBER, temporary_acting CLOB)

Which department has more than 1 head at a time? List the id, name and the number of heads.
SELECT T1.department_id, T1.name, COUNT(*) FROM management AS T2 JOIN department AS T1 ON T1.department_id = T2.department_id GROUP BY T1.department_id HAVING COUNT(*) > 1
SELECT "T1"."department_id", "T1"."name", COUNT(*) FROM "management" "T2" JOIN "department" "T1" ON "T1"."department_id" = "T2"."department_id" GROUP BY "T1"."department_id" HAVING COUNT(*) > 1