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

来自「guan yu pai ke xi tong de ruan jian」· SQL 代码 · 共 6 行

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