Exercitiul 1.

SELECT job
FROM emp
WHERE deptno = 20;

Exercitiul 2.

SELECT ename, dname, deptno
FROM emp, dept
WHERE emp.deptno = dept.deptno;

Exercitiul 3.

SELECT ename, dname, loc, job
FROM emp e, dept d
WHERE e.deptno = d.deptno
AND comm > 0;

Exercitiul 4.

SELECT e.ename, d.deptno, d.dname, e.job
FROM emp e, dept d
WHERE d.deptno = e.deptno
AND loc = 'CHICAGO';