View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A. Display the total number of products supplied by supplier 102 which have a product status of obsolete

B. Display the minimum PROD_LIST_PRICE for each product status

C. Display suppliers whose PROD_LIST_PRICE is less than 1000

D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

E. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

Correct Answer: D,E