Insert INTO

If you want to insert into a table value from another table or from CTE, make sure that you define columns to insert into a table then select * from cte/table. If you want to select into NEWTABLE from another table, there is no need to define columns to insert into.