Create temporal table in sql

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.

Similar codes

0 vote255 views1 answer
T-sql delete view if exists
SQL
0 vote277 views1 answer
FIND most frequent word in sql server
SQL
18 votes240 views6 answers
Laravel form validation
SQL
12 votes240 views2 answers
Delete all entries postgres
SQL
1 vote379 views1 answer
Postgres upgrade to superuser
SQL
0 vote237 views1 answer
Mariadb maximum left join
SQL
0 vote237 views1 answer
Mysql workbench not showing schemas
SQL
0 vote263 views1 answer
Insert into table with only identity column
SQL
0 vote245 views1 answer
Implicit inner join table alias
SQL
3 votes246 views1 answer
Postgresql today - 1 year
SQL