1,查询教师表中T2到T9之间工资大于2000并且有岗位津贴的教师所有字段数据
select * from teacher where no between "t2" and "t9"and sal>2000 and comm is not null;
2,查询教师表中教师姓名不以字母“A”开头的教师所有字段数据,用工资排序,去前三条
select * from teacher where name not like "a%" order by sal limit 3,7;
3,查询教师表中工资等于2000或者岗位津贴大于等于1000的教师所有字段数据
select * from teacher where sal=2000 or comm>=1000;