SELECT T2.department_name ,  T1.department_id FROM Degree_Programs AS T1 JOIN Departments AS T2 ON T1.department_id  =  T2.department_id GROUP BY T1.department_id ORDER BY count(*) DESC LIMIT 1
Which department offers the most number of degrees? List department name and id.
SELECT T2.department_name , T1.department_id FROM Degree_Programs AS T1 JOIN Departments AS T2 ON T1.department_id = T2.department_id GROUP BY T1.department_id ORDER BY count ( * ) DESC LIMIT 1
select t2 . department_name , t1 . department_id from degree_programs as t1 join departments as t2 on t1 . department_id = t2 . department_id group by t1 . department_id order by count ( * ) desc limit value
Which department offers the most number of degrees ? List department name and id .