[프로그래머스 - ORACLE] 조건에 부합하는 중고거래 상태 조회하기
CREATE 문 CREATE TABLE USED_GOODS_BOARD ( BOARD_IDVARCHAR(5)NOT NULL, WRITER_IDVARCHAR(50)NOT NULL, TITLEVARCHAR(100)NOT NULL, CONTENTSVARCHAR(1000)NOT NULL, PRICENUMBERNOT NULL, CREATED_DATEDATENOT NULL, STATUSVARCHAR(10)NOT NULL, VIEWSNUMBERNOT NULL ) 내 풀이 SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, CASE WHEN STATUS = 'DONE' THEN '거래완료' WHEN STATUS = 'SALE' THEN '판매중' WHEN STATUS = 'RESERVED' THE..
2023. 3. 22.
