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<10played more than 350 minutes? Return one number in a column named 'superstar'. 5) What is the average number of passes made by forwards? By midfielders? Write one query that gives both values with the corresponding position.
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<10played more than 350 minutes? Return one number in a column named 'superstar'. 5) What is the average number of passes made by forwards? By midfielders? Write one query that gives both values with the corresponding position.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.7CP
Related questions
Question
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<10played more than 350 minutes? Return one number in a column named 'superstar'.
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr