Tell me payment method code of the most recent payment.
select payment_method_code from payments order by date_payment_made desc limit 1
Tell me the amount of the most recent payment.
select amount_payment from payments order by date_payment_made desc limit 1
What is the most popular payment method?
select payment_method_code from payments group by payment_method_code order by count(*) desc limit 1