Views and CTEs

Views

Create a View

SELECT from the View

CTEs (Common Table Expression)

Create a CTE and SELECT FROM it and other tables