Anghami Interview Question

Advanced SQL using window function and different clauses