这里有一张选课信息表(course)（只展示了部分数据，数据

select name,count(*) as count from course  having count > 2 order by count desc;

select name,count(*) as count from course group by name and count > 2 order by count desc;

select name,count(*) as count from course group by name where count >= 2 order by count desc;

select name,count(*) as count from course group by name having count > 2 order by count desc;