Skip to main content

Peliqan

Try for free
Request a demo

Tanda

Average number of leaves taken per user

SQL query for Tanda

Calculate the average number of leaves taken by each user.

SELECT users.name, AVG(leaves.days_taken) AS avg_leaves FROM users JOIN leaves ON users.id = leaves.user_id GROUP BY users.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