Practice Interview Questions
| Question | Status |
|---|---|
Identify the top 10 quarterbacks with the highest points in a single game in 2016. Output the quarterback along with the corresponding game points. Organize records based on game points in descending order and present only the top 10 rows, without considering any ties in game points that might result in more than 10 quarterbacks in the output.
qbstats_2015_2016 table:
| Field | Description |
|---|---|
| qb | Name of QB |
| game_points | Number of points |
| year | Year of game |
Example output:
| Quarterback | Game Points |
|---|
Identify the top 10 quarterbacks with the highest points in a single game in 2016. Output the quarterback along with the corresponding game points. Organize records based on game points in descending order and present only the top 10 rows, without considering any ties in game points that might result in more than 10 quarterbacks in the output.
qbstats_2015_2016 table:
| Field | Description |
|---|---|
| qb | Name of QB |
| game_points | Number of points |
| year | Year of game |
Example output:
| Quarterback | Game Points |
|---|
| Drew Brees (D. Brees) | 49 |
| Matt Ryan (M. Ryan) | 48 |
| Drew Brees (D. Brees) | 48 |
| Marcus Mariota (M. Mariota) | 47 |
| Cam Newton (C. Newton) | 46 |
| Matt Ryan (M. Ryan) | 45 |
| Tyrod Taylor (T. Taylor) | 45 |
| Carson Palmer (C. Palmer) | 44 |
| Ben Roethlisberger (B. Roethlisberger) | 43 |
| Matt Ryan (M. Ryan) | 43 |
| Drew Brees (D. Brees) | 49 |
| Matt Ryan (M. Ryan) | 48 |
| Drew Brees (D. Brees) | 48 |
| Marcus Mariota (M. Mariota) | 47 |
| Cam Newton (C. Newton) | 46 |
| Matt Ryan (M. Ryan) | 45 |
| Tyrod Taylor (T. Taylor) | 45 |
| Carson Palmer (C. Palmer) | 44 |
| Ben Roethlisberger (B. Roethlisberger) | 43 |
| Matt Ryan (M. Ryan) | 43 |