164672.md

프로그래머스 164672

'조건에 부합하는 중고거래 상태 조회하기'

🔗 https://school.programmers.co.kr/learn/courses/30/lessons/164672

SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, 
CASE status
         WHEN 'sale' THEN '판매중'
         WHEN 'reserved' THEN '예약중' 
         WHEN 'done' THEN '거래완료'
    END status
FROM USED_GOODS_BOARD
WHERE CREATED_DATE LIKE '2022-10-05'
ORDER BY BOARD_ID DESC