INSERT INTO <table> (<columns>) SELECT <columns> FROM <tables> WHERE <conditionals>


And INSERTs don't require a columns list if the values match the column order of the table.

Never mind examples such as...

INSERT ALL
WHEN order_total < 1000000 THEN
INTO small_orders
WHEN order_total > 1000000 AND order_total < 2000000 THEN
INTO medium_orders
WHEN order_total > 2000000 THEN
INTO large_orders
SELECT order_id, order_total, sales_rep_id, customer_id
FROM orders;