Database: cre_Drama_Workshop_Groups
Question: Show all payment method codes and the number of orders for each code.
SQL:
SELECT payment_method_code ,  count(*) FROM INVOICES GROUP BY payment_method_code