MyTona interview question

SQL partition by task and general knowledge of SQL