Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are tasked with combining data from two tables: orders (2021 data) and orders_archive (2020 data). There might be duplicate rows between them. Which SQL statement will merge the data from both tables while removing duplicates?_
orders
orders_archive
A
SELECT * FROM orders INTERSECT SELECT * FROM orders_archive_
B
SELECT * FROM orders UNION SELECT * FROM orders_archive_
C
SELECT distinct * FROM orders JOIN orders_archive on order.id = orders_archive.id*
D
SELECT * FROM orders_archive MINUS SELECT * FROM orders_
E
SELECT * FROM orders UNION ALL SELECT * FROM orders_archive_
