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

 

 

 

---

풀이)

 

-- 코드를 입력하세요
SELECT CONCAT('/home/grep/src/', USED_GOODS_BOARD.BOARD_ID, '/', FILE_ID, FILE_NAME, FILE_EXT) FROM USED_GOODS_BOARD 
INNER JOIN USED_GOODS_FILE ON USED_GOODS_BOARD.BOARD_ID = USED_GOODS_FILE.BOARD_ID WHERE USED_GOODS_BOARD.VIEWS = (SELECT MAX(USED_GOODS_BOARD.VIEWS) FROM USED_GOODS_BOARD) ORDER BY FILE_ID DESC;