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

Question

Exhibit

Options

• Adisplay all products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of
• Bdisplay the total number of products supplied by supplier 102 and have a product status as
• Cdisplay the number of products whose PROD_LIST_PRICE is more than the average
• Ddisplay suppliers whose PROD_LIST_PRICE is less than 1000
• Edisplay the minimum PROD_LIST_PRICE for each product status

• A
  78% (40)
• B
  6% (3)
• D
  14% (7)
• E
  2% (1)

No community discussion yet for this question.