[Lv.2] 조건에 부합하는 중고거래 상태 조회하기 (CASE WHEN)

- Answer

SELECT BOARD_ID
    , WRITER_ID
    , TITLE
    , PRICE
    , CASE WHEN STATUS = 'SALE' THEN '판매중'
           WHEN STATUS = 'RESERVED' THEN '예약중'
           WHEN STATUS = 'DONE' THEN '거래완료'
      END AS STATUS
FROM USED_GOODS_BOARD
WHERE CREATED_DATE = '2022-10-05'
ORDER BY BOARD_ID DESC

- SQL Statement

Case When

조건문

CASE 'case_value'
    WHEN 'when_value' THEN 'statement_list'
    [WHEN 'when_value' THEN 'statement_list'] 
    ...
    [ELSE 'statement_list']
END

OR

CASE
    WHEN 'search_condition' THEN 'statement_list'
    [WHEN 'search_condition' THEN 'statement_list'] 
    ...
    [ELSE 'statement_list']
END

→ 조건 나열 후 END로 마무리해야 함.