create a table in sql and insert data from other table code example

Example: create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;