Question 9 Identify the error in the following subquery. SELECT OrderID, OrderDate, Freight FROM Orders WHERE Freight >

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Question 9 Identify the error in the following subquery. SELECT OrderID, OrderDate, Freight FROM Orders WHERE Freight >

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply