# Game Leaderboard — Aced

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/3067/game-leaderboard
Source observed: 2026-11-04T23:27:55.437Z
Last checked: 2026-11-04T23:27:55.437+00:00
Indexed: 2026-11-06T11:27:37.946+00:00

---

# Game Leaderboard

**Difficulty:** Hard  
**Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)  
**Interview:** Coding  
**Reported last asked:** 3 years ago

We provide this SQL interview question through Aced, formerly Exponent. Detailed company statistics require an [upgrade](https://www.aced.io/upgrade?src=questions). You can [sign up to run code](https://www.aced.io/signup?src=lesson).

## Problem

Zynga is a social game development company known for popular games played by millions worldwide. Within its games, players can form teams and compete. Each player's performance in different game sessions is recorded as a distinct score entry in the database.

You are given two tables, `players` and `scores`.

### `players`

| Column | Type |
|---|---|
| `player_id` | integer |
| `player_name` | string |
| `team_id` | integer |

### `scores`

| Column | Type |
|---|---|
| `score_id` | integer |
| `player_id` | integer |
| `game_score` | integer |

## Task

Write a SQL query that returns the top 2 players from each team, ranking players by their single highest score across all sessions.

If multiple players share the same highest score, include all tied players. Consequently, a team may have more than two returned players.

## Related questions

- [Duolingo Leaderboards](https://www.aced.io/questions/3099/duolingo-leaderboards)
- [Design a leaderboard system.](https://www.aced.io/questions/4674/design-leaderboard-system)

## Community and solution status

No community answers have been contributed. The question includes Question, Solution, and Community tabs; the community tab is labeled `Community11` in the accessible interface. The code editor and output area are available, while running code requires signing up.

## Other Aced resources

We offer interview preparation across these linked areas:

- [Courses](https://www.aced.io/courses?src=nav)
- [Loops](https://www.aced.io/guides?src=nav)
- [Experiences](https://www.aced.io/experiences?src=nav)
- [Browse all questions](https://www.aced.io/questions?src=nav)
- [Practice](https://www.aced.io/practice?src=nav)
- [Coaching](https://www.aced.io/coaching?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)
- [Job Referrals](https://www.aced.io/jobs/referrals?src=nav)
- [Blog](https://www.aced.io/blog?src=nav)
- [Resources](https://www.aced.io/resources?src=nav)
- [For universities](https://www.aced.io/pages/university?src=nav)
- [For businesses](https://www.aced.io/pages/business?src=nav)
- [For recruiters](https://www.aced.io/jobs/post?src=nav)

### Course areas

- [Product Management](https://www.aced.io/courses/pm?src=nav)
- [Forward Deployed](https://www.aced.io/courses/forward-deployed-engineering?src=nav)
- [Engineering Management](https://www.aced.io/courses/engineering-management?src=nav)
- [Software Engineering](https://www.aced.io/courses/software-engineering?src=nav)
- [System Design](https://www.aced.io/courses/system-design-interviews?src=nav)
- [Data Science](https://www.aced.io/courses/data-science?src=nav)
- [Machine Learning](https://www.aced.io/courses/ml-engineer?src=nav)
- [Data Engineering](https://www.aced.io/courses/data-engineering?src=nav)
- [AI Engineering](https://www.aced.io/courses/ai-engineering?src=nav)
- [Investment Banking](https://www.aced.io/ib?src=nav)
- [Generative AI](https://www.aced.io/courses/gen-ai-interviews?src=nav)
- [Security Engineer](https://www.aced.io/courses/security-engineer?src=nav)
- [TPM](https://www.aced.io/courses/tpm?src=nav)
- [Solutions Architect](https://www.aced.io/courses/solution-architect-interview?src=nav)
- [UX / Product Design](https://www.aced.io/courses/product-designer-interview?src=nav)
- [BizOps & Strategy](https://www.aced.io/courses/bizops?src=nav)

[Log in](https://www.aced.io/login?src=nav) or [sign up](https://www.aced.io/signup?src=nav).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3067%2Fgame-leaderboard&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3067%2Fgame-leaderboard). Opening a form does not execute a tool.