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.
The asterisk (*) operator selects all information.
