SELECT count(*) FROM inventory WHERE store_id  =  1
Count the number of items store 1 has in stock.
SELECT count ( * ) FROM inventory WHERE store_id = 1
select count ( * ) from inventory where store_id = value
Count the number of items store 1 has in stock .