Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Practice
5. Exercise 4
Summary

Instruction

Nicely done! On to the next exercise.

Exercise

For each district find the total area in square meters of hotels intersecting the district. Show the name of each district alongside the total hotel area (name this column total_area). Sort by the total area in descending order.

Stuck? Here's a hint!

Use SUM with ST_Area as its argument. Also, be sure to use ST_Transform with an SRID of 26910.