22,209
社区成员
发帖
与我相关
我的任务
分享
select top 1 COUNT(takes.ID)as student_num, time_slot_id
from takes, section
where takes.course_id=section.course_id
group by time_slot_id
order by student_num desc
select time_slot_id, MAX(student_num) as max_num
from (
select COUNT(takes.ID)as student_num, time_slot_id
from takes, section
where takes.course_id=section.course_id
group by time_slot_id
) as num_slot
group by time_slot_id