#常用运算符
#创建学生表students
create table students(id int ,name varchar(20),chinese int ,math int ,english int)
insert into students values(1,'张三',89,80,90),(2,'张思',67,73,98),(3,'王五',88,63,92),(4,'李四',55,87,60),(5,'吴无',75,65,90),(6,'王奇',75,65,90)
select * from students
#查询姓名为张三的学生
select * from students where name = '张三'
#查询英语成绩大于90的学生
select * from students where english > 90
#查询总分大于250分的学生
select * from students where (chinese+math+english)>250
#查询数学成绩大于90且语文成绩小于80的学生
select * from students where math > 90 and chinese < 80
#查询英语成绩大于数学成绩的学生
select * from students where english > math
#查询数学成绩大于70分且姓张的学生
select * from students where math > 70 and name like '张%'
#查询英语成绩在80到90分间的学生
select * from students where english between 80 and 90
select * from students where english in (80,90)
#查询数学成绩在89,90,91间的学生
select * from students where math in (89,90,91)
#查询所有姓李的学生
select * from students where name like '李%'