Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
Points
Polygons
32. Exercise 2
Summary

Instruction

Let's do one more exercise.

Exercise

Find the average area for each district type in San Francisco. Show the type of district in the first column and the average area in the second column. Your results should be in square meters.

Stuck? Here's a hint!

Use a GROUP BY clause to get the averages for each type of district. Use the right SRID (26910).