Mysql题目集（21-40）

10-21 查询学生表中大于19岁的女生

select sno as 学号,sname as 姓名,sex as 性别,mno as 专业,(2020-year(birdate)) as 年龄,memo as 备注
from stu
where (2020-year(birdate)) > 19 and sex = 0

10-22 查询年龄18-20之间的学生信息

select sno as 学号,sname as 姓名,sex as 性别,mno as 专业,(2020-year(birdate)) as 年龄,memo as 备注
from stu
where (2020-year(birdate)) between 18 and 20

10-23 查询姓‘李’的学生记录

select sno as 学号,sname as 姓名,sex as 性别,mno as 专业,birdate as 出生日期,memo as 备注
from stu
where sname like '李%';

10-24 查询部分专业的学生

select sno as 学号,sname as 姓名,sex as 性别,major.mname as 专业
from stu 
inner join major on major.mno = stu.mno
where major.mname = '计算机工程' or major.mname = '软件工程'
order by 学号 asc;