Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Window functions

How to summarize

Report a typo

Which string is suitable as a some_sum definition?

Select one option from the list

AVG(auditions) OVER (ROWS BETWEEN CURRENT ROW AND 2 PRECEDING) AS some_sum

SUM(auditions) OVER (ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING) AS some_sum

SUM(auditions) OVER (PARTITION BY performer ROWS BETWEEN CURRENT ROW AND 1 PRECEDING) AS some_sum

SUM(auditions) OVER (ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS some_sum

___

Create a free account to access the full topic