Your question is Top Games Among New Discord Users. 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 are given a table of Discord user gaming sessions. Write a SQL query to find the top 5 games played by users who joined Discord in the last 30 days. Return each game and the number of sessions played by those newly joined users, ordered from most played to least played.
This is an easy SQL question, so solve it using only the single table provided. Assume each row represents one game session, and use CURRENT_DATE as the reference date for the 30-day filter.
| Column | Type | Description |
|---|---|---|
| session_idPK | INT | Unique session identifier |
| user_id | INT | Discord user identifier |
| username | VARCHAR(50) | Discord username |
| joined_date | DATE | Date the user joined Discord |
| game_name | VARCHAR(100) | Name of the game played |
| session_minutes | INT | Length of the game session in minutes |