Skip to main content

Peliqan

Try for free
Request a demo

Tanda

Total hours worked per location

SQL query for Tanda

Calculate the total hours worked at each location.

SELECT locations.name, SUM(shifts.hours_worked) AS total_hours_worked FROM locations JOIN users ON locations.id = users.location_id JOIN shifts ON users.id = shifts.user_id GROUP BY locations.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