Database: customers_and_invoices
Question: How many accounts does each customer have? List the number and customer id.
SQL:
SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id