SQL Query Script :

SELECT ename,sal, job FROM emp
where hiredate >(select hiredate from emp
where sal =1500)

emp table

Oracle :

PostgreSQL