The data science team has reported that a column named 'average price' is missing from the 'sales' table. This column can be calculated using the 'units sold' and 'sales amount' columns. Which of the following SQL statements would correctly reload the data with the additional 'average price' column?

Real Exam

INSERT OVERWRITE sales SELECT , salesAmt/unitsSold as avgPrice FROM sales

13.5%

COPY INTO SALES AS SELECT , salesAmt/unitsSold as avgPrice FROM sales

10.8%

CREATE OR REPLACE TABLE sales AS SELECT , salesAmt/unitsSold as avgPrice FROM sales

53.0%

MERGE INTO sales USING (SELECT , salesAmt/unitsSold as avgPrice FROM sales)

12.9%

OVERWRITE sales AS SELECT , salesAmt/unitsSold as avgPrice FROM sales

9.9%

Databricks Certified Data Engineer - Associate