1) What player on a team with ia in the team name played less than 200 minutes and made more than 100 passes? Return the player surname. Note: To check if attribute A contains string S use "A like '%S%'"

%%sql

-- YOUR QUERY HERE

2.) Find all players who made more than 20 shots. Retuen all player information in descending order of shots made.

%%sql

-- YOUR QUERY HERE

3.) Find the goalkeepers of teams that played more than four games. List the surname of the goalkeeper, the team, and the number of minutes the goalkeeper played.

4) How many players who play on a team with ranking

5) What is the average number of passes made by forwards? By midfielders? Write one query that gives both values with the corresponding position.

6) Which team has the highest average number of passes per minute played? Return the team and average passes per minute. Hints: (1) You can compute a team's average number of passes per minute played by dividing the total number of passes by the total number of minutes. To force floating point division, multiply one operand by 1.0. (2) Consider using Limit.

[ ]: %%sq l -. YOUR QUERY HERE Your Turn - Basic SQL on World Cup Data (Graded) [ ]: \# Upload world cup data files \# Choose files Players.csu and Teams.csV - must be on Local computer from google.colab import files uploaded = files. upload( ( ) \# Then load tables from CSV files with open("Players.csv') as f : Players = pd.read_csv (f, index_col=0) Xsql drop table if exists Players; Xsql persist Players Xsql drop table if exists Teans; Xsql persist Teans Look at sample of Players and Teams tables