Find the state and country of all cities with post code starting with 4.
select state_province_county, country from addresses where zip_postcode like "4%"
What are the cities in Colorado that have post codes starting with 4.
select city from addresses where zip_postcode like "4%" and state_province_county = "Colorado"
How about cities in Texas that have post codes starting with 4?
select city from addresses where zip_postcode like "4%" and state_province_county = "Texas"
How many cities in total with post code starting with 4?
select count ( distinct city ) from addresses where zip_postcode like "4%"