作业

查看岗位是teacher的员工姓名、年龄

select name,age from teacher where post='teacher';
查看岗位是teacher且年龄大于30岁的员工姓名、年龄

select name,age from teacher where post='teacher' and age >30;
查看岗位是teacher且薪资在9000-1000范围内的员工姓名、年龄、薪资

select name,age,salary from teacher where salary >= 9000 and salary <= 10000;

或者

select name,age,salary from teacher where salary between 9000 and 10000;
查看岗位描述不为NULL的员工信息

select * from teacher where post is not null;
查看岗位是teacher且薪资是10000或9000或30000的员工姓名、年龄、薪资

select name,age,salary from teacher where salary in (10000,9000,30000);
查看岗位是teacher且薪资不是10000或9000或30000的员工姓名、年龄、薪资

select name,age,salary from teacher where salary not in (10000,9000,30000);
查看岗位是teacher且名字是jin开头的员工姓名、年薪

select name,round(salary*12,2) as year_salary from teacher where post='teacher'and name like 'jin%';

巴特西