SQL Query Script :
SELECT ename,sal, job FROM emp
where hiredate >(select hiredate from emp
where sal =1500)
emp table
Oracle :
PostgreSQL