CREATE TABLE Customers_cards (customer_id VARCHAR)

Show all customer ids and the number of cards owned by each customer.
SELECT customer_id, COUNT(*) FROM Customers_cards GROUP BY customer_id
SELECT "customer_id", COUNT(*) FROM "Customers_cards" GROUP BY "customer_id"