求1981年下半年入职的员工

select * from emp where extract(year from hiredate)=1981 and extract(month from hiredate)>6;

结果：