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 |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments