SELECT store_id FROM customer GROUP BY store_id ORDER BY count(*) DESC LIMIT 1
Return the id of the store with the most customers.
SELECT store_id FROM customer GROUP BY store_id ORDER BY count ( * ) DESC LIMIT 1
select store_id from customer group by store_id order by count ( * ) desc limit value
Return the id of the store with the most customers .