习题

'''
1. 查看岗位是teacher的员工姓名、年龄
2. 查看岗位是teacher且年龄大于30岁的员工姓名、年龄
3. 查看岗位是teacher且薪资在9000-1000范围内的员工姓名、年龄、薪资
4. 查看岗位描述不为NULL的员工信息
5. 查看岗位是teacher且薪资是10000或9000或30000的员工姓名、年龄、薪资
6. 查看岗位是teacher且薪资不是10000或9000或30000的员工姓名、年龄、薪资
7. 查看岗位是teacher且名字是jin开头的员工姓名、年薪

'''
select name, age from 表名 where position = 'teacher';

select name, age from 表名 where position = 'teacher' and age > 30;

select name, age, salary from 表名 where salary between 9000 and 10000;

select * from 表名 where position is not null;

select name, age from 表名 where position = 'teacher' and salary in (10000, 9000, 30000);

select name, age from 表名 where position = 'teacher' and salary not in (10000, 9000, 30000);

select name, salary from 表名 where name like "jin%";