Ultimate access to all questions.
A data engineering team has two tables: march_transactions
, containing all retail transactions for March, and april_transactions
, containing all transactions for April. There are no duplicate records between these tables. To create a new table, all_transactions
, that combines records from both march_transactions
and april_transactions
without duplicates, which SQL command should be used?