CREATE TABLE Accounts (customer_id VARCHAR)

Show the customer id and number of accounts with most accounts.
SELECT customer_id, COUNT(*) FROM Accounts GROUP BY customer_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "customer_id", COUNT(*) FROM "Accounts" GROUP BY "customer_id" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1