View the Exhibit and examine the structure of the ORDERS table.
Which task would require subqueries?
displaying the total order value for sales representatives 161 and 163
displaying the order total for sales representative 161 in the year 1999
displaying the number of orders that have order mode online and order date in 1999
displaying the number of orders whose order total is more than the average order total for all online orders