Skip to content

Files

Latest commit

7a7d3f2 · Oct 20, 2020

History

History

0512.Game Play Analysis II

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Oct 20, 2020
Oct 20, 2020
Aug 9, 2020

English Version

题目描述

None

解法

SQL

select player_id, device_id from Activity where (player_id, event_date) in ((select player_id, min(event_date) from Activity group by player_id))