2020-07-25

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

select first_name,salary from employees where not salary between 5000 and 12000;

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

select first_name,department_id from employees where department_id = 20 or 50;

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

select first_name,job_id from employees where manager_id is null;

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

select first_name,salary,commission_pct from employees where commission_pct is not null;

选择姓名中有字母a和e的员工姓名

select first_name from employees where first_name like ‘%a%’ and first_name like ‘%e%’