insert vs insert into select vs select into select

SQL insert statement is used to insert a new records in table.