SELECT statement to specify the columns we are interested in: player_id and the minimum event_date.FROM clause to specify the Activity table as the data source.GROUP BY clause to group the results by player_id.MIN() aggregate function to find the earliest event_date for each group.MIN() function as first_login to match the expected output column name.erDiagram
Activity {
int player_id
int device_id
date event_date
int games_played
player_id --|| event_date : is
}