SELECT store_id FROM customer GROUP BY store_id ORDER BY count(*) DESC LIMIT 1
Which store has most the 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
Which store has most the customers ?