On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
22. Spatial functions inside aggregates - exercise


Perfect! One more exercise coming your way.


For each district, show its name and the length of the longest railway track that intersects with it. Sort the results by length in descending order. Show the length in kilometers. Rename the second column to max.

Stuck? Here's a hint!

Use MAX(...) with ST_Length(...) as its argument. Don't forget to use ST_Transform.