Objectives: ALAS

select e.empno,e.ename, e.job from emp e where e.deptno = 20

emp table

 

Oracle:

PostgreSQL

MySQL