代码： # Write your MySQL query statement belowselect teacher_id,count(distinct(subject_id)) as cntfrom Teachergroup by teacher_id