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
正确答案:C,D
答案解析:有
微信扫一扫手机做题