Top 5 customers with highest total collections
SQL query for Twikey
Get the top 5 customers with the highest total collections from the collections table.
SELECT customer_id, SUM(amount) AS total_collections FROM collections GROUP BY customer_id ORDER BY total_collections DESC LIMIT 5
Twikey data model
Mandates
Transactions
Collections
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