how do i create temporary table using a common table expression?

The CREATE TABLE needs to be before the common table expression

create temp table foo
as
with cte1 as (
  ...
), cte2 as (
 ...
), cte3 as (
 ...
), cte4 as (
 ...
), cte5 as (
 ...
) 
select *
from cte5;