Canva Interview Question

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