data-engineer-associate video for you are working on a table called orders which contains data for 2021 and you have a second table called orders_archive which
You are working on a table called orders which contains data for 2021 and you have a second table called orders_archive which contains data for 2020. You need to combine the data from both tables, and there could be a possibility of the same rows between both tables. You want to combine the results and eliminate the duplicate rows. Which of the following SQL statements helps you accomplish this?