Top 5 users with the highest number of completed objectives
SQL query for Q7Leader
List the top 5 users with the highest number of completed objectives.
SELECT users.name, COUNT(objective.id) AS completed_objectives FROM users LEFT JOIN objective ON users.id = objective.completed_by WHERE objective.status = ‘completed’ GROUP BY users.name ORDER BY completed_objectives DESC LIMIT 5
Q7Leader data model
Vision
View 2 columns
Vision_idInteger
Vision_nameString
Talent
View 2 columns
Talent_idInteger
Talent_nameString
Competence
View 2 columns
Competence_idInteger
Competence_nameString
Performance
View 2 columns
Performance_idInteger
Performance_nameString
Attrition Risk
View 2 columns
Attrition_risk_idInteger
Attrition_risk_nameString
Operating
View 2 columns
Operating_idInteger
Operating_modeString
Profile Role
View 2 columns
Profile_role_idInteger
Expectation_profileString
Reward
View 2 columns
Reward_idInteger
Reward_nameString
Score
View 2 columns
ScoreString
Global_scoreString
Users
Department
Campaign
Member
Objective
Cycle
Customfield
Rdp
Rdp Family
Member Qprofiles
Member Qprofile Development Scans
Member Nextcareermoves
Member Custom Fields
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