Skip to main content

Peliqan

Try for free
Request a demo

Tanda

Total number of shifts per department

SQL query for Tanda

Count the total number of shifts for each department.

SELECT departments.name, COUNT(shifts.id) AS total_shifts FROM departments JOIN users ON departments.id = users.department_id JOIN shifts ON users.id = shifts.user_id GROUP BY departments.name

Try this query now in Tanda

Tanda data model

Tanda
Users

Tanda
Schedules

Tanda
Shifts

Tanda
Locations

Tanda
Departments

Tanda
Leaves

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