Average task expenses by department
SQL query for mWorker
Calculate the average task expenses for each department.
SELECT Departments.name, AVG(TaskExpenseTypes.amount) FROM Departments JOIN Employees ON Departments.id = Employees.department_id JOIN Tasks ON Employees.id = Tasks.employee_id JOIN TaskExpenseTypes ON Tasks.id = TaskExpenseTypes.task_id GROUP BY Departments.name
mWorker data model
Customer Contacts
Customers
Departments
Employees
Locations
Order Notes
Order Participants
Positions
Product Types
Projects
Suppliers
Tags
Tasks
Task Events
Task Hour Types
Task Expense Types
Terminals
Terminal Transactions
Transport Sites
Users
Vehicles
Contacts
Product Registration
Deliveries
Orders
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