Intel Corporation Interview Question

A SQL query that includes WINDOW FUNCTIONS, JOINS and more