BOLD Interview Question

SQL Window Function question , and joins