SCHEMA:
CREATE TABLE INVOICES (payment_method_code VARCHAR)
User Question:
Show all payment method codes and the number of orders for each code.


SELECT payment_method_code, COUNT(*) FROM INVOICES GROUP BY payment_method_code