Indium Software Interview Question

SQL questions based on window function