조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기

• 문제
  
• 정답

SELECT CONCAT('/home/grep/src/', BOARD.BOARD_ID, '/', FILE.FILE_ID, FILE.FILE_NAME, FILE.FILE_EXT) FILE_PATH
FROM USED_GOODS_BOARD BOARD JOIN USED_GOODS_FILE FILE ON BOARD.BOARD_ID = FILE.BOARD_ID
WHERE BOARD.BOARD_ID = (
    SELECT BOARD_ID
    FROM USED_GOODS_BOARD
    ORDER BY VIEWS DESC
    LIMIT 1)
ORDER BY FILE.FILE_ID DESC

• 결과