Mock interview. You're interviewing for a game data scientist job. The interviewer says: "Players on the forums say Frost is overpowered: it has the highest win rate. The design team is ready to weaken it. Should they?" You have the matches table, one row per match with the hero used and the result.
"Show each hero's matches and win rate, best first."
Expected output
hero, matches, win_rate (a percentage rounded to 1 decimal); sorted by win_rate, highest firstExample of the shape (made-up values):
| hero | matches | win_rate |
|---|---|---|
| Spark | 1500 | 57.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.