mysql练习2（对学生、专业课程的相关查询）

1.根据专业把年纪最大年龄的学员信息查询出来

SELECT * FROM student GROUP BY stu_major ORDER BY stu_age DESC LIMIT 3;

2.把每个学院的人数统计出来

SELECT stu_college,COUNT(*) FROM student GROUP BY stu_college;

3.查询女性，课程为计科的学生id及姓名

SELECT stu_id,stu_name FROM student WHERE stu_major = '计科' AND stu_sex = '女';

4.查询信工学院有哪些专业

SELECT stu_major FROM student WHERE stu_college = '信工学院';