Select from following answers:- SELECT ProductID FROM OrderDetail WHERE UnitPrice < 100.00 GROUP BY ProductID HAVING AVG(OrderQty) > 10 ORDER BY ProductID;

- SELECT ProductID FROM OrderDetail WHERE UnitPrice > 100.00 GROUP BY ProductID HAVING AVG(OrderQty) < 10 ORDER BY ProductID;
- SELECT ProductID FROM OrderDetail WHERE UnitPrice > 100.00 GROUP BY ProductID HAVING AVG(OrderQty) > 10 ORDER BY ProductID;
- All Above
This statement will generate a list of product IDs of products that cost less than $100.00 and have an average order quantity exceeding 10 units.
Show Correct Answer
Source: Microsoft Press book | |
Alert Moderator