SQL insert with select

This is possible to copy the table data from one table to another by using the SQL Insert into with select statement.
The insert into statement specifies the table where data needs to be copied. Whereas the select specifies where data should be copied from.

SQL IN operator

If you have a list of values to match in order to fetch rows from a database table, this is where the SQL IN operator works. The IN is a logical operator that takes a list of values to be matched to return records.