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