View the Exhibit and examine the data in the PRODUCT_INFORMATION table. Which two tasks would require subqueries? (Choose two.)

Question

Exhibit

Options

• Adisplaying all the products whose minimum list prices are more than average list price of products
• Bdisplaying the total number of products supplied by supplier 102071 and having product status
• Cdisplaying the number of products whose list prices are more than the average list price
• Ddisplaying all supplier IDs whose average list price is more than 500
• Edisplaying the minimum list price for each product status

• A
  81% (17)
• B
  10% (2)
• D
  5% (1)
• E
  5% (1)

No community discussion yet for this question.