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
Question 9 Identify the error in the following subquery. SELECT OrderID, OrderDate, Freight FROM Orders WHERE Freight >
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am