Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
12. Exercise 11


Precisely so. Looks like you really know what you're doing.


What are the average lengths among the bicycle routes that start in each district? Show each district's name alongside the average length in kilometers.

Stuck? Here's a hint!

You'll have to use AVG() with ST_Length and ST_Transform. Use an SRID of 26910 for San Francisco. Divide by 1000 to get kilometers. In order to get the highest precision for your final answer, first calculate the average in meters, and only then divide it by 1000.