Database: driving_school
Question: For each payment method, how many payments were made?
SQL:
SELECT payment_method_code ,  count(*) FROM Customer_Payments GROUP BY payment_method_code;