Database: customers_card_transactions
Question: Show the customer id and number of accounts with most accounts.
SQL:
SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id ORDER BY count(*) DESC LIMIT 1