Perfect! That was the last exercise in our quiz and you've done pretty well!

This is where our course ends. We've done quite a lot: single CTEs, multiple CTEs, nested CTEs, recursion, INSERT/UPDATE/DELETE with CTEs… pretty much everything you need in order to successfully use Common Table Expressions. We hope the knowledge you have gained will prove useful to you.

If you enjoyed the course, be sure to drop us a rating and explore some of our other courses! Maybe you’d like to also learn how to create sophisticated queries using GROUP BY extensions? Or perhaps you'd like to learn how to use analytic T-SQL functions in our Window Functions in MS SQL Server course? In any case, there's still a lot to learn about SQL – good luck on your adventure!