Pergunta de entrevista da empresa Canva

write a query for the given dataset (5 fields only) that would clean duplication, use window functions, have self merges