SQLITE SQL HELP

Merge two different sql files.

Now we have many different files that are doing the same thing: create tables, insert into values.

So I now want to create a new sql files that conbines all the data in these files.

You should use .read a.sql to read data from the input, and

You should use insert into table1 (c1, c2) select (c1,c2) from table 2;

You should delete temp tables we dont need. by the end we should only have the tables we had in common. For example:table of anmials. what we had in 5 sql files

You should run the script as many times as you want without having any errors.