Interview Query

Player Analysis

Start Timer

0:00:00

Upvote
4
Downvote
Save question
Mark as completed
View comments (20)
Next question

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

Loading comments