# Nth Ranked Player — SQL Interview Question

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/3068/nth-ranked-player
Source observed: 2026-11-04T22:31:23.126Z
Last checked: 2026-11-04T22:31:23.126+00:00
Indexed: 2026-11-05T03:52:21.462+00:00

---

# Nth Ranked Player

**Difficulty:** Medium  
**Category:** Coding · SQL  
**Interview history:** 1 interview; reported last asked 3 years ago

## Problem

Blizzard Entertainment is known for games including *World of Warcraft*, *StarCraft*, and *Overwatch*. Players receive rankings based on their performance.

You are given a table named `players`:

| player_id | player_name | score |
|---|---|---|
| integer | string | integer |

Blizzard wants to identify and reward players who narrowly missed leaderboards such as the Top 3 or Top 10. Write a SQL query that returns the **names, scores, and rankings** of the players ranked **4th, 6th, and 11th by score**.

The page uses SQLite in its code editor. The solution tab is locked behind the upgrade flow, and no community answers have been contributed. You can [upgrade](https://www.aced.io/upgrade?src=questions) for detailed company statistics or [sign up to run code](https://www.aced.io/signup?src=lesson).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F3068%2Fnth-ranked-player&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%2F3068%2Fnth-ranked-player). Opening a form does not execute a tool.