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.

Console

Code editor

Result

TableConsole