Skip to main content

Peliqan

Try for free
Request a demo

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

Try this query now in Teamleader

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