MyTona Interview Question

SQL partition by task and general knowledge of SQL