Introduction to Window Functions

SQL allows us to read a table using TABLE, select rows with a suitable WHERE clause, or groups of rows based on common criteria with GROUP BY. By those means, we can get only so far, though. For example, let us consider a scenario where an SQL table records the timestamps of a user’s session on a website: