# 출처: https://school.programmers.co.kr/learn/courses/30/lessons/164672
조건에 부합하는 중고거래 상태 조회하기

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