Question d’entretien chez Zeta

Sql questions. Advance sql window function. Output