Zeta interview question

Sql questions. Advance sql window function. Output