CREATE TABLE customer (store_id VARCHAR)

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 NULLS LAST LIMIT 1