Skip to main content

Peliqan

Try for free
Request a demo

AdminPulse

Number of tasks per team

SQL query for AdminPulse

Count the number of tasks assigned to each team.

SELECT team_id, COUNT(*) AS total_tasks FROM tasks GROUP BY team_id

Try this query now in AdminPulse

AdminPulse data model

AdminPulse
Invoices

AdminPulse
Relations

AdminPulse
Users

AdminPulse
Companies

AdminPulse
Tasks

AdminPulse
Documents

AdminPulse
Addresses

AdminPulse
Invoiceschedules

AdminPulse
Webhooks

AdminPulse
Assignmenttemplates

AdminPulse
Tasktemplates

AdminPulse
Teams

AdminPulse
Pricelistitems

AdminPulse
Pricetables

AdminPulse
Plannedregistrations

AdminPulse
Registrations

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