Number of employees in each role - AllGravy SQL Query - Peliqan

Number of employees in each role

SQL query for AllGravy

Count the number of employees in each role.

SELECT role_id, COUNT(employee_id) AS num_employees FROM employee_roles GROUP BY role_id

AllGravy data model

Employee Roles

Locations

Pulse Answers

Peoples

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.