SQL QUERIES WITH EXAMPLES

How to create a new table having the same structure as some other table?

create table new_table as select * from old_table

How to insert data into multiple tables?

There are two terms used INSERT ALL AND INSERT FIRST