누계 거리 순

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 sum(D_BETWEEN_DIST) desc

 

출력할 때 문자열로 바뀌므로, 순서정렬에서 계산을 다시 해줌