21-9-6(MySQL练习)

SELECT ename,job,sal 
from 
emp 
where
sal>2000 
and 
job in('MANAGER','SALESMAN');


SELECT ename,deptno,sal 
from 
emp 
where
deptno in(10,20) 
and 
sal BETWEEN 3000 and 5000;

SELECT ename,hiredate,job 
from
emp 
where 
hiredate between '1981-01-01' and  '1981-12-21' 
and 
job not like 'SALES%';


SELECT ename,job,deptno from emp 
where
job in('MANAGER','SALESMAN')
and
deptno in(10,20)
and 
ename like '%A%';