Schema: CREATE TABLE ADDRESSES (zip_postcode VARCHAR)
Question: How many addresses have zip code 197?
SQL: SELECT COUNT(*) FROM ADDRESSES WHERE zip_postcode = "197"