Player Analysis
Start Timer
0:00:00
You’ve been asked to analyze the player’s behaviors at a gaming company.
Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.
Example:
Input:
players table
| Column | Type |
|---|---|
| id | INTEGER |
| name | VARCHAR |
| games_played | INTEGER |
| registered_at | TIMESTAMP |
Output:
| Column | Type |
|---|---|
| players_more_than_5_to_10_games | INTEGER |
| players_10_plus_games | INTEGER |
.
.
.
.
.
.
.
.
.
Comments