SCHEMA:
CREATE TABLE Customers_cards (customer_id VARCHAR)
USER:
Show all customer ids and the number of cards owned by each customer.

QUERY:
SELECT customer_id, COUNT(*) FROM Customers_cards GROUP BY customer_id