What are all the invoices?
select * from invoices
Show all kinds of payment method codes among them.
select payment_method_code from invoices group by payment_method_code
Which one is used by most orders?
select payment_method_code from invoices group by payment_method_code order by count(*) desc limit 1