Alerzo Interview Question

SQL window functions, Use of subqueries