使用SQL Server CTE检索多个结果集

I was wondering how I can retrieve multiple result sets based on one CTE? Something like what I have below - but obviously this doesn't work. I was wondering how I can retrieve multiple res