Extract Player Demographics

EasySQL · PostgreSQL

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

CodePostgreSQL

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

Run your query to see results here.