Ultimate access to all questions.
A data engineering team manages retail transaction data across different months. They have two specific tables: the first table, named march_transactions
, contains all retail transactions recorded in the month of March, and the second table, named april_transactions
, holds all retail transactions for the month of April. It is assured that there are no duplicate records between these two tables. To consolidate this data, which of the following commands should be executed to create a new table all_transactions
that combines all records from both march_transactions
and april_transactions
, ensuring there are no duplicate records?