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

Question

Options

• ADisplay the minimum list price for each product status.
• BDisplay all suppliers whose list price is less than 1000.
• CDisplay the number of products whose list price is more than the average list price.
• DDisplay the total number of products supplied by supplier 102 and have product status as
• EDisplay all products whose minimum list price is more than the average list price of products and

• A
  5% (1)
• B
  11% (2)
• C
  74% (14)
• D
  11% (2)

No community discussion yet for this question.