List all payment methods and number of payments using each payment methods.
create table customer_payments (payment_method_code varchar, PRIMARY KEY (payment_method_code))
select payment_method_code, count(*) from customer_payments group by payment_method_code