[SQL문제풀기] 조건에 부합하는 중고거래 상태 조회하기

문제

MYSQL

내가 작성한 정답

SELECT board_id,writer_id,title,price,
        case 
         when status = 'DONE' then '거래완료'
         when status = 'SALE' then '판매중'
         when status = 'RESERVED' then '예약중'
        end as status
from used_goods_board
where created_date = '2022-10-05'
order by board_id desc

ORACLE

내가 작성한 정답 1 - to_char

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 to_char(created_date,'yymmdd') = '221005'
order by board_id desc

내가 작성한 정답 2 - to_date

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 = to_date('2022-10-05','yyyy-mm-dd')
order by board_id desc