Average number of employees per department
SQL query for NMBRS
Calculate the average number of employees per department.
SELECT d.department_name, AVG(e.total_employees) as avg_employees FROM departments d JOIN (SELECT department_id, COUNT(*) as total_employees FROM employees GROUP BY department_id) e ON d.department_id = e.department_id GROUP BY d.department_name
NMBRS data model
Debtors
Companies
Employees
Departments
Managers
Employee Fixedhours
Employee Variablehours
Leave Requests
Contracts
Employee Addresses
Leave Balances
Employee Functions
Company Addresses
Employments
Schedules
Employee Personal Info
Employee Fixedwagecomponents
Employee Variablewagecomponents
Employee Costcenters
Company Costcenters
Company Costunits
Company Hourcodes
Employee Departments
Company Wagemodels
Leave Groups
Employee Salaries
Employee Costperhour
Company Payroll Runs
Payroll Run Employees
Employee Extrafields
Employee Absences
Employee Parentalleave
Employee Details
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