Number of days off taken per user
SQL query for Tanda
Count the number of days off taken by each user.
SELECT users.name, COUNT(leaves.id) AS total_days_off FROM users JOIN leaves ON users.id = leaves.user_id GROUP BY users.name
Tanda data model
Users
Schedules
Shifts
Locations
Departments
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