Which task would require subqueries?

Prev Question
Next Question

View the Exhibit and examine the structure of the ORDERS table.

Exam 1Z0-047 - Which task would require subqueries?

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

Prev Question
Next Question

Leave a Reply

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