Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Window functions

Theory

Find the right one

Report a typo

Here you see a result of a query. Match the column name and the suitable string of this query.

name team score a b c d
Ivan red 5 10 9 7 5
Bianca red 9 10 9 7 9
Tom blue 10 10 10 8 10
Anna blue 7 10 10 8 7
Alexa blue 7 10 10 8 7
Match the items from left and right columns
AVG(score) OVER(PARTITION BY team)
MAX(score) OVER(PARTITION BY team)
SUM(score) OVER(PARTITION BY name)
MAX(score) OVER()
AS b
AS c
AS a
AS d
___

Create a free account to access the full topic