In this article I will give an introduction to what Common Table Expressions (CTE) are in the SQL Language. I will give some examples on how to use them, and thy they will help you in your SQL journey.

Window functions allow you to perform calculation against sets or rows (Windows), in a very flexible, clear and efficient way.