Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *