Indium Software Interview Question

questions using window functions of the SQL