Skip to main content

Peliqan

Try for free
Request a demo

Q7Leader

Number of members in each department

SQL query for Q7Leader

List the number of members in each department.

SELECT department.name, COUNT(member.id) FROM department LEFT JOIN member ON department.id = member.department_id GROUP BY department.name

Try this query now in Q7Leader

Q7Leader data model

Q7Leader
Vision

View 2 columns
Vision_idInteger
Vision_nameString
Q7Leader
Talent

View 2 columns
Talent_idInteger
Talent_nameString
Q7Leader
Competence

View 2 columns
Competence_idInteger
Competence_nameString
Q7Leader
Performance

View 2 columns
Performance_idInteger
Performance_nameString
Q7Leader
Attrition Risk

View 2 columns
Attrition_risk_idInteger
Attrition_risk_nameString
Q7Leader
Operating

View 2 columns
Operating_idInteger
Operating_modeString
Q7Leader
Profile Role

View 2 columns
Profile_role_idInteger
Expectation_profileString
Q7Leader
Reward

View 2 columns
Reward_idInteger
Reward_nameString
Q7Leader
Score

View 2 columns
ScoreString
Global_scoreString
Q7Leader
Users

Q7Leader
Department

Q7Leader
Campaign

Q7Leader
Member

Q7Leader
Objective

Q7Leader
Cycle

Q7Leader
Customfield

Q7Leader
Rdp

Q7Leader
Rdp Family

Q7Leader
Member Qprofiles

Q7Leader
Member Qprofile Development Scans

Q7Leader
Member Nextcareermoves

Q7Leader
Member Custom Fields

Q7Leader
Rdp Custom Fields

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