SELECT count(*) FROM inventory WHERE store_id  =  1
How many items in inventory does store 1 have?
SELECT count ( * ) FROM inventory WHERE store_id = 1
select count ( * ) from inventory where store_id = value
How many items in inventory does store 1 have ?