The table should be created by using the following syntax:

CREATE TABLE tablename
[(column, column, …)]
AS
(subquery);