SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id ORDER BY count(*) DESC LIMIT 1
What is the customer id of the customer with the most accounts, and how many accounts does this person have?
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
What is the customer id of the customer with the most accounts , and how many accounts does this person have ?