Common Table Expressions
Create a CTE named people and use it in the main query:
WITH chinstrap_penguins AS (
SELECT *
FROM penguins
WHERE species = 'Chinstrap'
)
SELECT *
FROM chinstrap_penguins;
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
Create a CTE named people and use it in the main query:
WITH chinstrap_penguins AS (
SELECT *
FROM penguins
WHERE species = 'Chinstrap'
)
SELECT *
FROM chinstrap_penguins;