BlackRock interview question

It was an SQL question, they were looking for a window function usage.