1.统计各系总人数
SELECT sdept 系别,COUNT(*) 人数
FROM student
GROUP BY + 列名
2.统计男女生总人数
SELECT ssex,COUNT(*) AS 总人数
FROM student
GROUP BY ssex;
3.统计各系男女生总人数
SELECT sdept,ssex,COUNT(*)
FROM student
GROUP BY sdept,ssex;
4.统计各系人数
SELECT sdept,COUNT(*) AS 各系女生人数
FROM student
WHERE ssex = '女' //WHERE ssex = '男'
GROUP BY sdept;
5.查询选修3门以上课程的学号
SELECT sno
FROM sc
GROUP BY sno
HAVING COUNT(*)>3;