Game Play Analysis ITable: ActivityColumn NameTypeplayer_idintdevice_idintevent_datedategames_playedint(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 an SQL query that reports the first login date for each player.The query result format is in the following example:Activity table:player_iddevice_idevent_idgames_played122016-03-015122016-05-026232017-06-251312016-03-020342018-07-035Result table:player_idfirst_login12016-03-0122017-06-2532016-03-02Optionsselect player_id, min(event_date) as first_loginfrom Activityby player_idorder by player_id;select player_id, min(event_date) as first_loginfrom Activitygroup by player_idorder by player_id;select player_id, min(event_date) as first_loginof Activitygroup by player_idorder by player_id;select min(event_date) as first_loginfrom Activitygroup by player_idorder by player_id;

Alter the Sessions Table: Add a new column SessionDuration to record the duration of each gaming session. The data type INTERVAL DAY TO SECOND is used to store durations.

A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Choose your favorite sport (e.g., hockey, cricket, football, baseball, etc.).

A person wants to play online games. Get the number of times he needs to play the game. Permit him to play the game till the count is exceeded. Two types of games can be played namely ‘Game 1’ and ‘Game 2’. Create a base class ‘Game’. From class, ‘Game’, two classes ‘Game 1’ and ‘Game 2’ can be derived. Each time the player plays the game a unique integer id is created for each match. Get the details like name, phone number, score obtained for both games. Find the credit obtained and display it along with the report.

A person wants to play online games. Get the number of times he needs to play the game. Permit him to play the game till the count is exceeded. Two types of games can be played namely ‘Game 1’ and ‘Game 2’. Create a base class ‘Game’. From class, ‘Game’, two classes ‘Game 1’ and ‘Game 2’ can be derived. Each time the player plays the game a unique integer id is created for each match. Get the details like name, phone number, score obtained for both games. Find the credit obtained and display it along with the report.  For each match, a score is get as input from the player and credits are given based on the following criteria.ScoreCredits<1001100 to 1502150 to 2003200 to 2504Only for the ‘Game 2’ get the  mail id too. If the mail id is having any ‘(  ‘ symbol remove it and format the mail id and print the formatted mail id.

WITH install AS ( SELECT el.user_id, el.create_time FROM event_logs el WHERE el.event_id = 'onboarding_login_view' AND el.referrer = 'plugin_installed' ) --first_usage_after_installed AS ( SELECT i.user_id, i.create_time, COALESCE(min(cr.event_time), toDateTime('1970-01-01 00:00:00')) AS first_event_time FROM install i LEFT JOIN chat_records cr ON i.user_id = cr.user_id WHERE cr.event_time > i.create_time GROUP BY i.user_id, i.create_time帮我修改代码，我要展现出用户安装后第一次使用的功能，即使没有使用也要