Teamleader

Number of tasks completed per project

SQL query for Teamleader

Count the number of tasks that have been completed for each project.

SELECT p.name as project_name, COUNT(t.id) as tasks_completed FROM projectsv2 p LEFT JOIN tasksv2 t ON p.id = t.project_id WHERE t.status = ‘completed’ GROUP BY p.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