Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Quiz
4. Question 3
Congratulations

## Instruction

Excellent! The third question is waiting for you.

## Exercise

For each district type, show its type and the total distance in kilometers of all bicycle routes fully contained within the single districts. Order the results by total length in descending order. Use geometry type.

Note: in order to get the highest precision for your final answer, first calculate the sum of route lengths in meters, and only then divide the sum by 1000.