[프로그래머스, Lv.2] 조건에 부합하는 중고거래 상태 조회하기 (mysql)

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

프로그래머스

728x90

---

SELECT board_id, writer_id, title, price,
    CASE
    WHEN status = 'SALE' THEN '판매중'
    WHEN status = 'DONE' THEN '거래완료'
    WHEN status = 'RESERVED' THEN '예약중'
    END AS status
FROM used_goods_board as ugb
where created_date = '2022-10-05'
ORDER BY board_id DESC