select * from 班级 a left join (select 班级id,count(*) as counta from 学生 group by 班级id) b on a.班级id=b.班级id
where b.counta=(select top 1 COUNT(*) as counta from StudioNews group by UserID order by counta desc) 可能存在人数最多的不止一个班级
select top 1 max(学生ID) as result from 学生, 班级 where 学生.班级ID=班级.班级ID group by 班级 order by result desc;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024