The table shows data for four players in a football team. Players Games played Total time on field (minutes)Asmee 4 104Larisa 7 175Rishit 8 152Yash 5 135Question promptWhich player spent the most time on the field per game?Question response areaSelect one optionAsmeeLarisaRishitYash

Game Play Analysis IIITable: 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 for each player and date, how many games played so far by the player. That is, the total number of games played by the player until that date. Check the example for clarity.The query result format is in the following example:Activity table:player_iddevice_idevent_idgames_played122016-03-015122016-05-026132017-06-251312016-03-020342018-07-035Result table:player_idevent_dategames_played_so_far12016-03-01512016-05-021112017-06-251232016-03-02032018-07-035For the player with id 1, 5+6=11 games played by 2016-05-02, and 5+6+1=12 games played by 2017-06-25. For the player with id 3, 0+5=5 games played by 2018-07-03. Note that for each player we only care about the days when the player logged in.Optionsselect player_id, event_date, games_played_so_farfrom ( select player_id, event_date, @games := if(player_id = @player, @games + games_played, games_played) as games_played_so_far, @player := player_id from (select * from Activity order by player_id, event_date) as a,) as t;select games_played_so_farfrom ( select player_id, event_date, @games := if(player_id = @player, @games + games_played, games_played) as games_played_so_far, @player := player_id from (select * from Activity order by player_id, event_date) as a, (select @player := -1, @games := 0) as tmp) as t;select player_id, event_date, games_played_so_farfrom ( select player_id, event_date, @games := if(player_id = @player, @games + games_played, games_played) as games_played_so_far, @player := player_id from (select * from Activity order by player_id, event_date) as a, (select @player := -1, @games := 0) as tmp) as t;select player_id, event_date, games_played_so_far select player_id, event_date, @games := if(player_id = @player, @games + games_played, games_played) as games_played_so_far, @player := player_id from (select * from Activity order by player_id, event_date) as a, (select @player := -1, @games := 0) as tmp) as t;Finish

This graph shows how many goals two football teams scored in three different matches.Question promptWhat was the average (mean) number of goals scored by Team A?Question response areaSelect one option1.522.33

Question 5You’re a data analyst for a sports arena who wants to better understand their customers who attend soccer games. At every event, attendees are asked to fill out a survey. The sports arena keeps the responses in the data table CustomerSurveys. Which query should you use to examine only the data from customers who attended soccer games? 1 pointSELECT event = 'soccer'FROM CustomerSurveys;SELECT *FROM CustomerSurveysWHERE 'soccer';SELECT *FROM CustomerSurveysWHERE event = 'soccer';SELECT *FROM CustomerSurveysFILTER = 'soccer';

A group of friends went fishing in a lake.This table shows the number of different types of fish they caught.Type of fish  Number of fishTrout 14Bluegill 22Walleye 4Question promptWhich pie chart best shows the same data?Question response areaSelect one option

Answer the statistical measures and create a box and whiskers plot for the following set of data., On this question page, you will first be asked to fill in statistical measures, then create a box plot. Once you make adjustments to the box plot, the answer area will appear and you will be able to submit your answers.3, comma, 3, comma, 4, comma, 5, comma, 5, comma, 7, comma, 7, comma, 12, comma, 123,3,4,5,5,7,7,12,12Min: Q1: Med: Q3: Max: