SQL Tutorial - Common Table Expression (CTEs) with Examples

In this SQL for Business Analysis tutorial we are looking at Common Table Expressions (CTEs) which are perfect for simplifying complicated queries, making them easier to read and simpler to work with.
The SQL CTE is defined by a With Clause and is easy to work with,
You start with defining the CTE name as
SYNTAX
With name
AS(
SQL Query
),
name 2 AS () - If adding another CTE
Once CTEs are defined the user can select from the CTE using its names as a table name.
Select * from Name - Select Statement
In the video we show from example for Google BigQuery public datasets.
Ask below if you have any questions.