Syniti interview question

Group by , Cte , overlapping date ranges, duplicate detection