[SELECT/LEVEL1] 조건에 부합하는 중고거래 댓글 조회하기 (MySQL/Oracle)

MySQL

SELECT    A.TITLE
        , A.BOARD_ID
        , B.REPLY_ID
        , B.WRITER_ID
        , B.CONTENTS
        , DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE
FROM USED_GOODS_BOARD A, USED_GOODS_REPLY B
WHERE A.BOARD_ID = B.BOARD_ID
AND DATE_FORMAT(A.CREATED_DATE, '%Y-%m') = '2022-10'
ORDER BY B.CREATED_DATE ASC, A.TITLE ASC;

---

Oracle

SELECT    A.TITLE
        , A.BOARD_ID
        , B.REPLY_ID
        , B.WRITER_ID
        , B.CONTENTS
        , TO_CHAR(B.CREATED_DATE, 'YYYY-MM-DD')
FROM USED_GOODS_BOARD A, USED_GOODS_REPLY B
WHERE A.BOARD_ID = B.BOARD_ID
  AND TO_CHAR(A.CREATED_DATE, 'YYYYMM') = '202210'
ORDER BY B.CREATED_DATE, A.TITLE;