Common Table Expressions

Subquery Types

Create derived table

Join derived tables

Pre-aggregate data

What is derived table?

Why use derived tables?

Derived table vs CTE?

Derived Tables Guide