Introduction
Practice
12. Exercise 11
Summary

Instruction

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

Exercise

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.

Console

Code editor

Result

TableConsole