framework/resources/Functional/window_functions/negative/q22.sql

-- DRILL-3359
select avg(salary) over(partition by position_id order by salary rows between 1 preceding  and 1 following) from cp.`employee.json`;