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

Question

Exhibit

Options

• ADisplay the number of products whose PROD_LIST_PRICE is more than the average
• BDisplay suppliers whose PROD_LIST_PRICE is less than 1000
• CDisplay products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all
• DDisplay the total number of products supplied by supplier 102 which have a product status of
• EDisplay the minimum PROD_LIST_PRICE for each product status

• A
  83% (20)
• B
  4% (1)
• D
  4% (1)
• E
  8% (2)

No community discussion yet for this question.