Number of mandates per customer - Twikey SQL Query - Peliqan

Number of mandates per customer

SQL query for Twikey

Count the number of mandates per customer from the mandates table.

SELECT customer_id, COUNT(*) AS num_mandates FROM mandates GROUP BY customer_id

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.