The table is created with no rows if the query returned no rows.
SQL> CREATE TABLE Y AS SELECT * FROM X WHERE 1 = 2; SQL>