FreeWheel interview question

SQL window function questions for unequal join