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