SELECT count(students.教师号) as 人数, teachers.姓名
from students,teachers
where teachers.教师号 = students.教师号
group by teachers.教师号, teachers.姓名
SELECT count(students.教师号) as 人数, teachers.姓名
from students inner join teachers
on teachers.教师号 = students.教师号
group by teachers.教师号
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024