[프로그래머스, Lv.3] 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기 (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/164671

프로그래머스

728x90

---

SELECT CONCAT('/home/grep/src/', ugb.board_id, '/', file_id, file_name, file_ext) as file_path
FROM used_goods_board as ugb, used_goods_file as ugf
WHERE
views = (
    SELECT max(views)
    FROM used_goods_board
)
AND ugb.board_id = ugf.board_id
ORDER BY file_id DESC