Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. You can read more about windowed aggregations and see examples of their usage on data.world in our SQL documentation.
Here is a list of all the new windowed functions with links to their reference pages: