SQLD · 60회 변형 · 어려움 난이도 · 35번

SELECT ORD_NO,
       ORD_AMT,
       ORD_AMT * 0.1 AS VAT,
       '정상' AS GUBUN,
       CASE WHEN ORD_AMT >= 50000 THEN 'Y' ELSE 'N' END AS FREE_SHIP
  FROM ORD
UNION ALL
SELECT ORD_NO,
       ORD_AMT,
       ORD_AMT * 0.1,
       '취소',
       'N'
  FROM ORD_CANCEL;