Discover Interview Question

Create a query using CTE's as opposed to a sub-query.