Highest Spending Customer
Largest total delivered payment amount.
LIMIT 1
Loading analytics…
Repeat Customers
Customers with more than one order (HAVING COUNT(*) > 1).
HAVING
Loading analytics…
Top Customers by Revenue
Delivered payment revenue per customer, highest to lowest.
payments.amount
Loading analytics…
Customer City Revenue
Delivered payment revenue grouped by customer city.
GROUP BY city
Loading analytics…