Amazon Interview Question

SQL questions that involved the use of window functions and ctes.