. Add `GET /api/v1/courses/:id/leaderboard` endpoint

[DeFiVC]

What: Add a per-course leaderboard showing top performers by quiz score.

Why: Course-level competition drives engagement. Users want to see how they rank against others taking the same course.

Scope: Create endpoint that queries quiz submissions for a specific course, aggregates scores per user, and returns top 20 with rank, displayName, and average score.

Acceptance criteria:

• Returns top 20 users for a specific course
• Sorted by average quiz score
• Includes number of quizzes taken
• Cached for 5 minutes

Technical context: src/modules/quizzes/quiz.service.ts — quiz queries. src/database/schema.ts:113-142 — quizSubmissions.

---

[habnark]

@habnark has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hello can i work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @habnark to this issue.

[Komelove]

@Komelove has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I’d be happy to take this issue. I’ve looked through the requirements and have a plan for approaching the implementation. I’ll investigate the existing code and dependencies, make the required changes, verify the behaviour with tests, and provide a concise PR explaining what was changed. I can start immediately and will communicate any blockers during development.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Komelove to this issue.

[devgbmuyiwa]

@devgbmuyiwa has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hello can i work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @devgbmuyiwa to this issue.

[chidii]

@chidii has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi Maintainer, reviewed the issue in detail. Full stack background with solid experience relevant to this task. No blockers on my end — I'm ready to submit a PR shortly. Please assign.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @chidii to this issue.

[CollinsKRO]

@CollinsKRO has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi, I can fix this kindly assign.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @CollinsKRO to this issue.

[TS-mfon]

@TS-mfon has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

GM

i'm a blockchain developer

please can i work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @TS-mfon to this issue.

[Clinton6801]

@Clinton6801 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello boss, I've gone through the issue description and i'd love to work on this issue. Kindly assign me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Clinton6801 to this issue.

[onyinyechinwokwu-success]

@onyinyechinwokwu-success has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Let me squash this issue!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @onyinyechinwokwu-success to this issue.

[oluborodeabiodun22-prog]

@oluborodeabiodun22-prog has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

interested in working on this issue. I understand the requirements and can deliver a solution that meets the expected outcome.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @oluborodeabiodun22-prog to this issue.

[ayandipe]

@ayandipe has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hi Maintainer,

Kindly assign this issue to me. I’m confident I can provide a prompt and precise resolution.

Regards,
John

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ayandipe to this issue.

[babawo96]

@babawo96 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I have reviewed this issue and I would like to work on it

ℹ️ Repo Maintainers: To accept this application, review their application or assign @babawo96 to this issue.

[M2u0i0z]

@M2u0i0z has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

I understand the expected outcome and would love to work on this. I'll provide a solution that satisfies the acceptance criteria.
Please I'm ready to work 🙏 Boss

ℹ️ Repo Maintainers: To accept this application, review their application or assign @M2u0i0z to this issue.

[praizehimm]

@praizehimm has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

hello can i work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @praizehimm to this issue.

[itzkingaddie]

@itzkingaddie has applied to work on this issue as part of the Stellar Wave Program's 8th wave.

Hello, I have gone through the issue and understand the expected outcome. I am interested in taking this task and believe I can complete it effectively.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @itzkingaddie to this issue.