Which statement would provide the desired result?

Prev Question
Next Question

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

Exam 1Z0-047 - Which statement would provide the desired result?

Your manager asked you to get the SALES_REP_ID and the total numbers of orders placed by each of the sales representatives.

Which statement would provide the desired result?

A.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders
GROUP BY sales_rep_id;

B.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders
GROUP BY sales_rep_id, total_orders;

C.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders;

D.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders
WHERE sales_rep_id IS NOT NULL;

Prev Question
Next Question

Leave a Reply

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