SQLD · 제60회 · 35번

SELECT EMPNO,
       ENAME,
       EXTRACT(YEAR FROM HIREDATE) AS YR,
       SAL
 FROM EMP
UNION
SELECT EMPNO,
       ENAME,
       EXTRACT(YEAR FROM HIREDATE),
       SAL
 FROM EMP_HIST;