Archive Old Orders
Write the statements that move all orders placed before 2026-01-01 from Orders into Orders_Archive (same columns) and remove them from Orders.
Table schema
Orders(id INT PRIMARY KEY, order_date DATE, amount INT)
Orders_Archive(id INT PRIMARY KEY, order_date DATE, amount INT)Sample data
Orders:
id | order_date | amount
1 | 2025-12-20 | 100
2 | 2026-01-05 | 200
3 | 2025-06-01 | 50
Orders_Archive: empty
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.