Find the state and country of all cities with post code starting with 4.
CREATE TABLE addresses (state_province_county VARCHAR, country VARCHAR, zip_postcode VARCHAR)
SELECT state_province_county, country FROM addresses WHERE zip_postcode LIKE "4%"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE addresses (state_province_county VARCHAR, country VARCHAR, zip_postcode VARCHAR) Question: Find the state and country of all cities with post code starting with 4. [/INST] SELECT state_province_county, country FROM addresses WHERE zip_postcode LIKE "4%" </s>