WITH temp AS
(
...
)
SELECT *
FROM temp
CONCAT를 활용하 문자열을 붙일 수 있음
CASE 표현식
SELECT orderNo, orderDate
CASE
WHEN status = 'In Process' THEN '처리중'
WHEN status = 'Shipped' THEN '배송중'
WHEN status = 'Resolved' THEN '완료'
WHEN status = 'Disputed' THEN '문제해결증'
WHEN status = 'On Hold' THEN '보류'
ELSE '없음'
END AS status
FROM orders
WHERE YEAR(orderDate) = 2005 AND MONTH(orderDate) = 5;