View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?

Question

Exhibit

Options

• Adisplaying the total order value for sales representatives 161 and 163
• Bdisplaying the order total for sales representative 161 in the year 1999
• Cdisplaying the number of orders that have order mode online and order date in 1999
• Ddisplaying the number of orders whose order total is more than the average order total for all online orders

• A
  3% (1)
• B
  6% (2)
• C
  13% (4)
• D
  77% (24)

No community discussion yet for this question.