SQL 알고리즘 코드카타 23일차(2) 26.01.21(수)

부제:

조건에 부합하는 중고거래 댓글 조회하기, 레벨 5

 

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/164673
2. 정답 코드: 

SELECT
    ugb.title,
    ugb.board_id,
    ugr.reply_id,
    ugr.writer_id,
    ugr.contents,
    date_format(ugr.created_date, "%Y-%m-%d") as created_date
from used_goods_board as ugb
join used_goods_reply as ugr
    on ugb.board_id = ugr.board_id
where ugb.created_date like "2022-10%"
order by created_date asc, title asc

3. 오류 상황:

SELECT
    ugb.title,
    ugb.board_id,
    ugr.reply_id,
    ugb.writer_id,
    ugb.contents,
    date_format(ugb.created_date, "%Y-%m-%d") as created_date
from used_goods_board as ugb
join used_goods_reply as ugr
    on ugb.board_id = ugr.board_id
where ugb.created_date like "2022-10%"
order by created_date asc, title asc

=> 컬럼 출처 오류

4. 시도 방법:

=> 컬럼 출처 수정

5. 최종 문제 해결 방법:

=> 댓글 사용자 ID, 댓글 내용, 댓글 작성일은 'USED_GOODS_REPLY' 테이블에서 호