Question: how to copy data from one table to another using insert?
Answer: INSERT INTO SELECT copies data from one table to another table. INSERT INTO SELECT requires that data types in source and target tables match.