SQLD · 60회 변형 · 보통 난이도 · 35번

SELECT DEPTNO,
       DNAME,
       SUBSTR(LOC, 1, 2) AS LOC2
  FROM DEPT
UNION
SELECT DEPTNO,
       DNAME,
       SUBSTR(LOC, 1, 2)
  FROM DEPT_CLOSED;