how to insert a value from another table in sql code example

Example: create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;