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
10. Exercise 9
Summary

Instruction

You're doing great so far! keep it up.

Exercise

How many households of different types are there within the Ingleside district? Show the following columns:

  • name of the district,
  • the total number of single parent family households - name the column single_parent
  • the total number of the nonfamily households - name the column nonfamily,
  • the total number of the two-parent family households - name the column both_parents.

Stuck? Here's a hint!

Use ST_Within to find households that are in the Ingleside district.