04运算符练习

题目

1.选择工资不在5000到12000的员工的姓名和工资

select first_name,last_name from employees where salary < 5000 || salary > 12000;

2.选择在20或者50号部门工作的员工姓名和部门号

select first_name,last_name,department_id from employees where department_id = 20 || department_id = 50;

3.选择公司中没有管理者的员工姓名及job_id

select first_name,last_name,job_id from employees where manager_id <=> NULL;

4.选择公司中有奖金的员工姓名，工资和奖金级别

select first_name,last_name,commission_pct from employees where commission_pct is not NULL;

5.选择员工姓名的第三个字母是a的员工姓名

select first_name from employees where first_name like '__a%';

6.选择姓名中有a和k的员工姓名

select first_name from employees where first_name like '%a%' and first_name like '%k%';

7.显示出表employees表中first_name以’e’结尾的员工信息

select first_name from employees where first_name like '%e';

8.显示出表employees部门编号在8–100之间的姓名，工种

select first_name,job_id from employees where department_id >= 80 and department_id <= 100;

9.显示出表employees的manager_id是100，101，110的员工姓名，工资，管理这id

select first_name,salary,manager_id from employees where manager_id in (100,101,110);