Database: student_transcripts_tracking
Question: What is the name and id of the department with the most number of degrees ?
SQL:
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