Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostGIS

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.