Total number of vehicles by supplier
SQL query for mWorker
Count the total number of vehicles for each supplier.
SELECT Suppliers.name, COUNT(*) FROM Suppliers JOIN Vehicles ON Suppliers.id = Vehicles.supplier_id GROUP BY Suppliers.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