Database: driving_school
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;