13，分组查询（2）小练习

1，-- 根据speciality分组，查看每组里的姓名

select speciality,GROUP_CONCAT(s_name) from students GROUP BY speciality

2，-- 根据gender分组，查看每组里的姓名

select gender,GROUP_CONCAT(s_name) from students GROUP BY gender

3，-- 根据speciality分组，使用聚合函数count()计算组里的人数

select GROUP_CONCAT(s_name),count(*),speciality from students GROUP BY speciality ORDER BY count(*) desc

4，-- 根据speciality分组，查看性别为男的信息

select speciality,gender,count(*),GROUP_CONCAT(s_name) from students GROUP BY speciality,gender HAVING gender = '男' order by count(*) desc