Creation should include using the following syntax:
CREATE TABLE tablename[(column, column, …)]AS(subquery);