Amazon Interview Question

Utilize window functions to extract info based on schema.