[Programmers] 284531번 - 노선별 평균 역 사이 거리 조회하기 [MySQL]

문제 링크

---

1. 문제 풀이

ROUND 함수로 반올림을 수행하고, CONCAT 함수로 단위를 붙여줬다.

---

2. 쿼리

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 SUM(D_BETWEEN_DIST) DESC;

---