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