Total hours worked by each employee - Simplicate SQL Query - Peliqan

Total hours worked by each employee

SQL query for Simplicate

Get the total hours worked by each employee.

SELECT p.first_name || || p.last_name AS employee_name, SUM(h.hours_worked) AS total_hours_worked FROM persons p INNER JOIN employees e ON p.id = e.person_id LEFT JOIN hours h ON e.id = h.employee_id GROUP BY e.id

Simplicate data model

Organization Industries

Organizations

Organization Sizes

Person Genders

Relation Types

Employee Civil Statuses

Employee Contract Types

Employee Types

Employment Types

Employees

Webhooks

Webhook Logs

Countries

Persons

Sales

Sales Services

Sales Service Hour Types

Sales Service Cost Types

Vatcodes

Costtypes

Deafult Services

Revenuegroup

Organization Profiles

Hour Types

Webhook Actions

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.