반응형
CREATE 문
CREATE TABLE USED_GOODS_BOARD (
BOARD_ID VARCHAR(5) NOT NULL,
WRITER_ID VARCHAR(50) NOT NULL,
TITLE VARCHAR(100) NOT NULL,
CONTENTS VARCHAR(1000) NOT NULL,
PRICE NUMBER NOT NULL,
CREATED_DATE DATE NOT NULL,
STATUS VARCHAR(10) NOT NULL,
VIEWS NUMBER NOT NULL
)
- 내 풀이
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;
댓글