Pregunta de entrevista de MyTona

SQL partition by task and general knowledge of SQL