Levi Strauss Interview Question

SQL assessment with window functions and aggregates