LeetCode刷题-数据库（MySQL）- 512.Game Play Analysis II

512.Game Play Analysis II

一、题目描述

Table: Activity

Column Name	Type
player_id	int
device_id	int
event_date	date
games_played	int

(player_id, event_date) is the primary key of this table.
This table shows the activity of players of some game.
Each row is a record of a player who logged in and played a number of games (possibly 0) before logging out on some day using some device.

Write a SQL query that reports the device that is first logged in for each player.
The query result format is in the following example:
Activity table:

player_id	device_id	event_date	games_played