SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id ORDER BY count(*) DESC LIMIT 1
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 limit value
Show the customer id and number of accounts with most accounts .