Skip to main content
All Problems
medium0% acceptance

Customers Using Multiple Payment Methods

Find customers who have used more than one distinct payment method across all their orders. Return the customer's full name, the number of distinct payment methods they've used, and their total spending. Sort by distinct_methods descending.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
emailTEXT
phoneTEXTNULL
cityTEXT
stateTEXT
countryTEXT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute