insert data from 1 table to another code example

Example: create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;