---

View the Exhibit and examine the data in the PRODUCT INFORMATION table. Which two tasks would require subqueries？ （）
A: displaying the minimum list price for each product status
B: displaying all supplier IDs whose average list price is more than 500
C: displaying the number of products whose list prices are more than the average list price
D: displaying all the products whose minimum list prices are more than the average list price of products having the product status orderable
E: displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE

---

出自：Oracle认证

显示答案