Month: March 2018

Write an SQL query and identify first login date for each gamer.   Input Table: gamers_activity player_id device_id event_date games_played 7 22 2017-04-02 4 7 22 2017-06-05 3 9 33 2018-02-26 0 6 11 2017-05-07 7 6 44 2019-08-06 3   Output Table: player_id first_login 7 2017-04-02 9 2017-04-02 6 2017-04-02 Explanation: “gamers_activity” table shows the activity … Read more

Write a SQL query that identify the device that was first used to log in for each gamer.   Input Table: gamers_activity player_id device_id event_date games_played 7 22 2017-04-02 4 7 22 2017-06-05 3 9 33 2018-02-26 0 6 11 2017-05-07 7 6 44 2019-08-06 3   Output Table: player_id device_id 7 22 9 33 … Read more