List of companies with the highest number of debtors
SQL query for NMBRS
Get a list of companies with the highest number of debtors.
SELECT c.company_name, COUNT(d.debtor_id) as num_debtors FROM companies c JOIN debtors d ON c.company_id = d.company_id GROUP BY c.company_name ORDER BY num_debtors DESC
NMBRS data model
Debtors
Companies
Company Addresses
Company Costcenters
Company Costunits
Company Hourcodes
Company Payroll Runs
Company Schedules
Company Wagemodels
Contracts
Departments
Employee Absences
Employee Addresses
Employee Costcenters
Employee Costperhour
Employee Departments
Employees
Employee Details
Employee Extrafields
Employee Fixedhours
Employee Fixedwagecomponents
Employee Functions
Employee Labouragreements
Employee Parentalleave
Employee Personal Info
Employee Salaries
Employee Variablehours
Employee Variablewagecomponents
Employments
Leave Balances
Leave Groups
Leave Requests
Managers
Payroll Run Employees
Schedules
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