Schema: CREATE TABLE inventory (store_id VARCHAR)
Question: How many items in inventory does store 1 have?
SQL: SELECT COUNT(*) FROM inventory WHERE store_id = 1