Watershed interview question

Complex joins and CTEs in SQL