On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Relationships Between Geometries
ST_Distance and ST_Dwithin
Spatial joins practice
18. Get to know sf_household_types


Great! Before we move on, we need to present one more new table from our database. This one is called sf_household_types.


Select all information from the table sf_household_types.

This table stores census information about the number of specific households in a given census block.

A census block is always part of a planning district, and there are usually more than 20 census blocks in a single planning district. Here, you will find information about three types of households in each census block: both_parents_family_household, single_parent_family_household and nonfamily_household.

Stuck? Here's a hint!

The asterisk (*) operator selects all information.