Leveling up your mind
The WITH clause stores the result of a query in a temporary table (temporary_movies) using an alias.
WITH
temporary_movies
Multiple temporary tables can be defined with one instance of the WITH keyword.