解题思路:很简单,只是一个普通的select语句。
代码如下:
# Write your MySQL query statement below
select teacher_id,count(distinct subject_id) as cnt
from Teacher
group by teacher_id;
解题思路:很简单,只是一个普通的select语句。
代码如下:
# Write your MySQL query statement below
select teacher_id,count(distinct subject_id) as cnt
from Teacher
group by teacher_id;