Table 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