INSERT from a SELECT in SQL

SQL interview exercise on Modifying Data, difficulty 2 of 3. Solve it in the editor beside a worked example; the tests run the moment you do.

Copy every order placed before 1 February 2024 into the empty order_archive table, which has the same columns. Leave the orders table as it is.

Each exercise pairs a worked example with a twin problem to solve in a real editor; the tests run the moment you do. Progress is saved in your browser, and in your account if you sign in.

More Modifying Data in SQL

• INSERT a row
• UPDATE some rows
• DELETE in the right order
• Insert or update (UPSERT)

All SQL exercises · Other languages and frameworks