SQL INSERT .. SELECT sql command copy data from table to table

This SQL command may not use frequently. But I think should be have useful for some people, I'm talking about "INSERT INTO ... SELECT", The SQL Command for insert data to table from another data table

The Syntax of this SQL command is:
INSERT INTO "table1" ("column1", "column2")
SELECT "column3", "column4"
FROM "table2"

THE EXAMPLE
If you want to puts data from "Orders" table which is order purchased in 2007 to keep the other one, can create query like follow this:

INSERT INTO Orders2007(order_id, date_purchased, amount)
SELECT order_id, date_purchased, amount
FROM Orders
WHERE Year(date_purchased) = 2007;

That's it will get data which is order purchased in 2007 to "Order2007" table.
This SQL statement is like a copy to some records into another table.