Zeta Interview Question

Sql questions. Advance sql window function. Output