View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()
A: displaying the total order value for sales representatives 161 and 163
B: displaying the order total for sales representative 161 in the year 1999
C: displaying the number of orders that have order mode online and order date in 1999
D: displaying the number of orders whose order total is more than the average order total for all online orders
出自:Oracle认证