Scenario: In a database with a Orders table containing columns OrderID, CustomerID, and TotalAmount, which SQL query would create a view named HighValueOrders to retrieve orders with a total amount greater than $1000?$

Context:

Orders Table Columns:

OrderID

CustomerID

TotalAmount

A

CREATE VIEW HighValueOrders AS

SELECT OrderID, CustomerID, TotalAmount

FROM Orders

WHERE TotalAmount $>1000$;

B

CREATE VIEW HighValueOrders AS

SELECT OrderID, CustomerID, TotalAmount

FROM Orders

GROUP BY TotalAmount

HAVING TotalAmount $>1000$;

C

CREATE VIEW HighValueOrders AS

SELECT $*$

FROM Orders

WHERE TotalAmount $>1000$;

D

CREATE VIEW HighValueOrders $($OrderID$,$ CustomerID, TotalAmount$)$ AS

SELECT $*$

FROM Orders

WHERE TotalAmount $>1000$;

Previous