1WITH new_table AS (
2 SELECT *
3 FROM existing_table
4 WHERE distance >= 20)
5
6# You can then run multiple queries on this filtered data without
7#having to filter the data everytime write complex subqueries.
8# NB WITH/temporal tables is always defined first before writing queries.