-- create a table
CREATE TABLE ACTIVITY (
    player_id INT, 
    event_date DATE,
    device_id INT NOT NULL,
    games_played INT NOT NULL,
    CONSTRAINT PK_Person PRIMARY KEY (player_id, event_date)

);
-- insert some values
INSERT INTO ACTIVITY (player_id, device_id, event_date, games_played) VALUES (1, 2, '2018-03-01', 5);
INSERT INTO ACTIVITY (player_id, device_id, event_date, games_played) VALUES (1, 2, '2016-03-01', 6);
INSERT INTO ACTIVITY (player_id, device_id, event_date, games_played) VALUES (2, 3, '2017-03-01', 0);
INSERT INTO ACTIVITY (player_id, device_id, event_date, games_played) VALUES (3, 1, '2019-03-01', 2);
INSERT INTO ACTIVITY (player_id, device_id, event_date, games_played) VALUES (3, 4, '2022-03-01', 7);

-- fetch some values
SELECT (PLAYER_ID), MIN(event_date) AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID;