Number of employees in each company category
SQL query for BambooHR
This query will return the number of employees in each company category.
SELECT company_category, COUNT(*) FROM company_categories JOIN employees_directory ON company_categories.company_id = employees_directory.company_id GROUP BY company_category
BambooHR data model
Employees Directory
Employee Dependents
Employee Last Change
Company Categories
Timeoff Types
Timeoff Policies
Timeoff Requests
Job Summaries
Hiring Leads
Application Statuses
Applications
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