with t as(select player_id,min(event_date)as d
from activity
groupby player_id
)select a.player_id, a.device_id
from activity as a, t
where a.event_date = t.d and a.player_id = t.player_id
select a1.player_id, a1.device_id
from activity as a1
where a1.event_date <=ALL(select a2.event_date
from activity as a2
where a1.player_id = a2.player_id
)
with t as (select player_id, min(event_date) as dfrom activitygroup by player_id)select a.player_id, a.device_idfrom activity as a, twhere a.event_date = t.d and a.player_id = t.player_idselect a1.player_id, a1.device_idfrom activity as a1where