View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? By Singh | January 1, 2023 0 Comment View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks require subqueries? (Choose two.) A. Display suppliers whose PROD_LIST_PRICE is less than 1000 B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable D. Display the total number of products supplied by supplier 102 which have a product status of obsolete E. Display the minimum PROD_LIST_PRICE for each product status Correct Answer: B,C