For anyone who doesn't know, CTE = common table expression, which is a part of a query representing a temporary result set that can be referenced from other par

For anyone who doesn't know, CTE = common table expression, which is a part of a query representing a temporary result set that can be referenced from other parts of a query.