Total number of deals per business type
SQL query for Teamleader
Get the total number of deals for each business type.
SELECT bt.name as business_type, COUNT(d.id) as total_deals FROM businessTypes bt LEFT JOIN deals d ON bt.id = d.business_type_id GROUP BY bt.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.
- 14-day free trial
- No credit card needed