Which statement would provide the desired result?

View the Exhibit and examine the description of the ORDERS table. 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?

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

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;



Leave a Reply 1

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


miriam

miriam

This was a bit too easy… is this for SQL expert exam?