출처

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

문제

풀이

WITH TOP_BOARD AS (
    SELECT BOARD_ID
    FROM USED_GOODS_BOARD
    ORDER BY VIEWS DESC
    LIMIT 1)
   
SELECT CONCAT("/home/grep/src/", BOARD_ID, "/", FILE_ID, FILE_NAME, FILE_EXT) AS FILE_PATH
FROM USED_GOODS_FILE F
WHERE F.BOARD_ID = (
    SELECT *
    FROM TOP_BOARD)
ORDER BY FILE_ID DESC