119. View the Exhibit and examine the data in the PRODUCT_INFORMATION table.
Which two tasks would require subqueries? (Choose two.)
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
Answer: CD
快速定位,需要跟平均值比较,要子查询的,B容易干扰判断
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718927/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
