Which payment method is used the most often?
SELECT Payment_Method_Code FROM Payments GROUP BY Payment_Method_Code ORDER BY count(*) DESC LIMIT 1
payment method used the most often refers to MAX(COUNT(Payment_Method_Code));