SQLD · 모의고사 5회 · 40번

SELECT ID, VAL,
       MAX(VAL) OVER () AS M,
       SUM(VAL) OVER (ORDER BY ID) AS S,
       FIRST_VALUE(VAL) OVER (
         ORDER BY ID
         ROWS BETWEEN 10 PRECEDING AND 10 FOLLOWING
       ) AS F
FROM T
ORDER BY ID;