Number of meetings per user
SQL query for Teamleader Focus
Count the number of meetings each user has attended.
SELECT users.name, COUNT(meetings.id) AS num_meetings FROM users JOIN meetings ON users.id = meetings.user_id GROUP BY users.name
Teamleader Focus data model
Activity Types
Business Types
Call Outcomes
Calls
Closing Days
Companies
Contacts
Credit Notes
Current User
Custom Field Definitions
Day Off Types
Deal Sources
Deal Phases
Deals
Departments
Events
Expenses
Invoices
Invoice Lines
Lost Reasons
Materials
Meetings
Milestones
Notes Companies
Notes Contacts
Notes Deals
Orders
Payment Terms
Pipelines
Product Categories
Products
Project Groups
Projectsv
Notes Projectsv
Project Lines
Quotations
Quotation Lines
Subscriptions
Tags
Tasksv
Tax Rates
Teams
Tickets
Time Tracking
Units Of Measure
Users
Users Info
Users Get Week Schedule
Users List Days Off
Work Types
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