SELECT store_id FROM inventory GROUP BY store_id ORDER BY count(*) DESC LIMIT 1
What is the id of the store that has the most items in inventory?
SELECT store_id FROM inventory GROUP BY store_id ORDER BY count ( * ) DESC LIMIT 1
select store_id from inventory group by store_id order by count ( * ) desc limit value
What is the id of the store that has the most items in inventory ?