Move every order placed before 1 March 2024 from orders into orders_archive (copy them, then remove them from orders). Their order_items stay as they are.
Tables
customers
customer_idinteger
namevarchar
cityvarchar
statevarchar
signup_datedate
emailvarchar
phonevarchar
referred_byinteger
order_items
order_idinteger
product_idinteger
quantityinteger
unit_priceinteger
orders
order_idinteger
customer_idinteger
order_datedate
statusvarchar
payment_methodvarchar
orders_archive
order_idinteger
customer_idinteger
order_datedate
statusvarchar
payment_methodvarchar
products
product_idinteger
product_namevarchar
categoryvarchar
priceinteger
stockinteger
Hints(0/2)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP