Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostGIS

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.