Database: cre_Students_Information_Systems
Question: Which teacher teaches the most courses? Give me the id of the teacher and the number of courses he or she teaches.
SQL:
SELECT count(*) ,  teacher_id FROM Classes GROUP BY teacher_id ORDER BY count(*) DESC LIMIT 1