CREATE TABLE customers (payment_method VARCHAR2)

Which payment method is used by most customers?
SELECT payment_method FROM customers GROUP BY payment_method ORDER BY COUNT(*) DESC LIMIT 1
SELECT "payment_method" FROM "customers" GROUP BY "payment_method" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY