Extract Player Demographics

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Extract Player Demographics. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Write a SQL query to extract player demographics from a user database for Zynga.

Use the users table and return the available demographic attributes for every player. Preserve NULL values where demographic information is missing.

Output

One row per player
Columns: player_id, age, gender, and country
Include every player and sort by player_id in ascending order

Schema

users

Column	Type	Description
player_idPK	INTEGER	Unique identifier for the player
age	INTEGER	Player age in years
gender	VARCHAR(30)	Player-reported gender
country	VARCHAR(100)	Player country

Tablesusers

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results