Question 9 Identify the error in the following subquery. SELECT OrderID, OrderDate, Freight FROM Orders WHERE Freight >
Posted: Mon Jul 11, 2022 9:50 am
Question 9 Identify the error in the followingsubquery.
SELECT OrderID, OrderDate, Freight
FROM Orders
WHERE Freight >
SELECT AVG(Freight)
FROM Orders
ORDER BY Freight
-The subquery is missing an alias
- A semicolon is missing at the end
-Missing parentheses
-The ORDER BY clause is not coded correctly
SELECT OrderID, OrderDate, Freight
FROM Orders
WHERE Freight >
SELECT AVG(Freight)
FROM Orders
ORDER BY Freight
-The subquery is missing an alias
- A semicolon is missing at the end
-Missing parentheses
-The ORDER BY clause is not coded correctly