I had never used CTEs in SQL Server before, so I asked the interviewer to briefly explain them to me. After his explanation, we had a short discussion where I talked about how CTEs would be helpful in some of the things we do in data warehousing with ETL.