"""
출처:프로그래머스,
https://school.programmers.co.kr/learn/courses/30/lessons/284531
"""

"""
select ROUTE,
    concat(cast(round( sum(D_BETWEEN_DIST),1) as char),"km") "TOTAL_DISTANCE",
    concat(cast(round( avg(D_BETWEEN_DIST),2) as char),"km") "AVERAGE_DISTANCE" 
from SUBWAY_DISTANCE
group by ROUTE
order by sum(D_BETWEEN_DIST) desc
"""