Average deal amount by contact
SQL query for Zoho CRM
Calculate the average deal amount for each contact.
SELECT contact_id, AVG(amount) FROM deals GROUP BY contact_id
Zoho CRM data model
Users
Leads
Contacts
Deals
Tasks
Accounts
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