SELECT T2.Name ,  COUNT(*) FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID  =  T2.Teacher_ID GROUP BY T2.Name
Show names of teachers and the number of courses they teach.
SELECT T2.Name , COUNT ( * ) FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID = T2.Teacher_ID GROUP BY T2.Name
select t2 . name , count ( * ) from course_arrange as t1 join teacher as t2 on t1 . teacher_id = t2 . teacher_id group by t2 . name
Show names of teachers and the number of courses they teach .