Top 10 loyal customers by total spend
SQL query for Mews
Get the top 10 customers with the highest total spend.
SELECT c.name, SUM(p.amount) AS total_spend FROM customers c JOIN payments p ON c.id = p.customerid GROUP BY c.name ORDER BY total_spend DESC LIMIT 10
Mews data model
Accountingcategories
Accountingitems
Accountnotes
Addresses
Agecategories
Availabilityblocks
Availabilityadjustments
Bills
Businesssegments
Cashiers
Cashiertransactions
Commands
Companies
Companionships
Companycontracts
Configuration
Counters
Countries
Creditcards
Currencies
Customers
Departments
Devices
Exchangerates
Languages
Loyaltymemberships
Loyaltyprograms
Loyaltytiers
Messagethreads
Orderitems
Outletitems
Outlets
Payments
Paymentrequests
Products
Productcategories
Productserviceorders
Rates
Rategroups
Reservations
Reservationgroups
Resourceaccesstokens
Resourceblocks
Resources
Resourcecategories
Resourcecategoryassignments
Resourcefeatures
Restrictions
Rules
Routing Rules
Services
Sources
Sourceassignments
Serviceoverbookinglimits
Tasks
Taxenvironments
Taxation
Vouchers
Vouchercodes
Voucherassignments
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed