Teamleader

Total number of meetings per user

SQL query for Teamleader

Get the total number of meetings scheduled for each user.

SELECT u.name as user_name, COUNT(m.id) as total_meetings FROM users u LEFT JOIN meetings m ON u.id = m.user_id GROUP BY u.name

Teamleader data model

Teamleader
Table Companies

Teamleader
Table Contacts

Teamleader
Table Business Types

Teamleader
Table Tags

Teamleader
Table Deals

Teamleader
Table Quotations

Teamleader
Table Meetings

Teamleader
Table Calls

Teamleader
Table Call Outcomes

Teamleader
Table Events

Teamleader
Table Invoices

Teamleader
Table Credit Notes

Teamleader
Table Subscriptions

Teamleader
Table Products

Teamleader
Table Product Categories

Teamleader
Table Time Tracking

Teamleader
Table Tickets

Teamleader
Table Users

Teamleader
Table Work Types

Teamleader
Table Activity Types

Teamleader
Table Milestones

Teamleader
Table Projectsv

Teamleader
Table Tasksv

Teamleader
Table Project Groups

Teamleader
Table Materials

Teamleader
Table Current User

Teamleader
Table Custom Field Definitions

Use SQL on all your SaaS data

Magical SQL for Teamleader with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Ask AI willl write your SQL queries from plain English