[프로그래머스] 노선별 평균 역 사이 거리 조회하기

□ 문제 URL

노선별 평균 역 사이 거리 조회하기

□ 문제 풀이

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

□ ETC

• CONCAT() 함수로 데이터에 'km' 추가