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
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 as t2 join department as t1 on t1 . department_id = t2 . department_id group by t1 . department_id having count ( * ) > value
Which department has more than 1 head at a time ? List the id , name and the number of heads .