https://blog.frankxue.ca/posts/how-to-use-window-functions-in-sql/