select ename from emp
/
select ename, hiredate from emp where deptno = 20
/
select sum(sal) from emp
/
select ename, job, sal from emp where sal > 2800 and job = 'MANAGER'
/
select ename from emp where emp.deptno in (select deptno from dept where loc='DALLAS')
/
select ename, job, sal from emp where deptno = 30 order by sal
/
select distinct dname from (select dname from dept) union (select job from emp)
/
select empno, ename from emp where ename like 'M%'and sal >= 1290
/
select d.loc
from dept d, emp e
where e.ename = 'ALLEN' and d.deptno = e.deptno
/
select distinct d.dname
from dept d, emp e
where d.deptno = e.deptno
and e.job in ('CLERK','SALESMAN','ANALYST')
/
select distinct e1.empno, e1.ename
from emp e1, emp e2
where e1.job = 'MANAGER'
and e1.deptno = e2.deptno
and e2.comm > 0
/
select empno, ename
from emp, dept
where sal > 1000
and emp.deptno = dept.deptno
and dept.loc in ('DALLAS','CHICAGO')
/