Autodesk Interview Question

SQL window function and Python (straightforward)