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 DATE '2025-05-27' as the reference date for the 30-day filter.
Note: Treat DATE '2025-05-27' as today's date.
game_name first and play_count second.game_name ascending.game_name is NULL.| 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 |