Luxoft interview question

SQL Coding Test, Rolling Sum, Sliding Window, LAST_VALUE