Average transaction amount per mandate - Twikey SQL Query - Peliqan

Average transaction amount per mandate

SQL query for Twikey

Calculate the average transaction amount per mandate from the transactions table.

SELECT mandate_id, AVG(amount) AS avg_amount FROM transactions GROUP BY mandate_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.