Number of orders by project
SQL query for mWorker
Count the number of orders for each project.
SELECT Projects.name, COUNT(*) FROM Projects JOIN Orders ON Projects.id = Orders.project_id GROUP BY Projects.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