최대 1 분 소요

문제 링크

정답

-- SUBWAY_DISTANCE: LINE, NO, ROUTE, STATION_NAME, D_BETWEEN_DIST, D_CUMULATIVE

SELECT ROUTE, 
    CONCAT(ROUND(SUM(D_BETWEEN_DIST), 1), "km") AS TOTAL_DISTANCE, 
    CONCAT(ROUND(AVG(D_BETWEEN_DIST), 2), "km") AS AVERAGE_DISTANCE
FROM SUBWAY_DISTANCE
GROUP BY ROUTE
ORDER BY ROUND(SUM(D_BETWEEN_DIST), 1) DESC;

✅ Point

  • 총 누계거리를 기준으로 정렬
    • ORDER BY 2 DESC; 로 하면 틀림!
      • 숫자가 아닌 문자열을 기준으로 정렬할 경우, 문제 발생 가능