1.查询教员所带班级数量的多少按降序排列(显示教员名字和数量).sql

guan yu pai ke xi tong de ruan jian

select [name], count(Teachings.TeacherId) as countent 
from Teachings
inner join Teachers
on (Teachings.TeacherId = teachers.TeacherId)
group by [name]
order by countent desc