CREATE TABLE INVOICES (payment_method_code VARCHAR)

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
SELECT "payment_method_code", COUNT(*) FROM "INVOICES" GROUP BY "payment_method_code"