Schema: CREATE TABLE Customer_Payments (payment_method_code VARCHAR)
Question: List all payment methods and number of payments using each payment methods.
SQL: SELECT payment_method_code, COUNT(*) FROM Customer_Payments GROUP BY payment_method_code