Database: cre_Students_Information_Systems
Question: List the detail and id of the teacher who teaches the most 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