Database: cre_Students_Information_Systems
Question: What are the detail and id of the teacher who teaches the largest number of courses?
SQL:
SELECT T1.teacher_details ,  T1.teacher_id FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id GROUP BY T1.teacher_id ORDER BY count(*) DESC LIMIT 1