Let AI do the work for you
Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.
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
Table Customer Contacts
Table Customers
Table Departments
Table Employees
Table Locations
Table Order Notes
Table Order Participants
Table Positions
Table Product Types
Table Projects
Table Suppliers
Table Tags
Table Tasks
Table Task Events
Table Task Hour Types
Table Task Expense Types
Table Terminals
Table Terminal Transactions
Table Transport Sites
Table Users
Table Vehicles
Table Contacts
Table Product Registration
Table Deliveries
Table Orders
Magical SQL for mWorker with Peliqan.io
Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.
- Power BI
- Metabase
- Tableau
