Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Window functions

Choose the partition

Report a typo

Which string is suitable as a some_col definition?

Select one option from the list

AVG(score) OVER (PARTITION BY category ROWS BETWEEN CURRENT ROW AND 2 FOLLOWING) AS some_col

AVG(score) OVER (PARTITION BY year ROWS BETWEEN CURRENT ROW AND 2 FOLLOWING) AS some_col

AVG(score) OVER (PARTITION BY month ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS some_col

AVG(score) OVER (PARTITION BY id ROWS BETWEEN CURRENT ROW AND 1 PRECEDING) AS some_col

___

Create a free account to access the full topic