Hello and welcome to the second part of our CTE course. In the previous part, you checked your current knowledge of SQL. Now, it's time for real fun to begin.

We're going to teach you basic CTEs. This part may not present new possibilities in SQL, but treat it as an introduction to more advanced topics. For now, it's important that you get the basics right.

As always, we'll start off by introducing the tables we're going to work with.