Find the state of all cities with post code starting with 4.
select state_province_county from addresses where zip_postcode like "4%"
Find the country of all cities with post code starting with 4.
select country from addresses where zip_postcode like "4%"
List all the post codes starting with 4.
select zip_postcode from addresses where zip_postcode like "4%"