Number of tasks per department - Gripp SQL Query - Peliqan

Number of tasks per department

SQL query for Gripp

Count the number of tasks assigned to each department.

SELECT d.department_name, COUNT(t.task_id) AS task_count FROM departments d JOIN tasks t ON d.department_id = t.department_id GROUP BY d.department_name

Gripp data model

Absencerequests

Bulkprices

Calendaritems

Companies

Contacts

Contracts

Costs

Costheadings

Departments

Employees

Employee Yearly Leave Budgets

Employmentcontracts

Files

Invoices

Hours

Ledgers

Memorials

Offers

Offerphases

Packets

Payments

Priceexceptions

Projects

Products

Purchaseinvoices

Purchaseorders

Purchasepayments

Tags

Tasks

Taskphases

Timeline Entries

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.