강의로 돌아가기
MySQL 정답 공유 (함정 주의)
마지막 ORDER BY 할 때 total_distance로 하면 'km'가 포함되므로 틀리니 ROUND(SUM(d_between_dist), 1)로 정렬해야 함.
SELECT
route,
CONCAT(ROUND(SUM(d_between_dist), 1), 'km') total_distance,
CONCAT(ROUND(AVG(d_between_dist), 2), 'km') average_distance
FROM subway_distance
GROUP BY route
ORDER BY ROUND(SUM(d_between_dist), 1) DESC
-
감사합니다~
이혜미―2025.06.24 15:31
답변 쓰기