CREATE TABLE Customer_Payments (payment_method_code VARCHAR)

List all payment methods and number of payments using each payment methods.
SELECT payment_method_code, COUNT(*) FROM Customer_Payments GROUP BY payment_method_code
SELECT "payment_method_code", COUNT(*) FROM "Customer_Payments" GROUP BY "payment_method_code"