목록2024/02/05 (1)
짜리몽땅 매거진
![](http://i1.daumcdn.net/thumb/C150x150/?fname=https://blog.kakaocdn.net/dn/bbdUql/btsEtlRuYn5/mlKZMUDXW2SUwXXRWQcpJ1/img.png)
문제1. 조건에 부합하는 중고거래 댓글 조회하기 출처 : 프로그래머스 SQL 고득점 kit - SELECT 문제 정보 : LEVEL 1 / 정답률 61% https://school.programmers.co.kr/learn/courses/30/lessons/164673 정답 쿼리 SELECT TITLE, B.BOARD_ID, REPLY_ID, B.WRITER_ID, B.CONTENTS, DATE_FORMAT(B.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE FROM USED_GOODS_BOARD AS A JOIN USED_GOODS_BOARD AS B ON A.BOARD_ID = B.BOARD_ID WHERE A.CREATED_DATE BETWEEN '2022-10-01' A..
Data/SQL
2024. 2. 5. 14:39