Average deal value per company - Teamleader SQL Query - Peliqan

Average deal value per company

SQL query for Teamleader

Calculate the average deal value for each company.

SELECT c.name as company_name, AVG(d.value) as avg_deal_value FROM companies c LEFT JOIN deals d ON c.id = d.company_id GROUP BY c.name

Teamleader data model

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.