HI WELCOME TO KANSIRIS

How do I create a table based on another table

select * into newtable from oldtable
 SELECT * INTO schema.newtable FROM schema.oldtable WHERE 1 = 0;
CREATE TABLE schema.newtable AS SELECT * FROM schema.oldtable;