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 WHERE
sales_rep_id IS NOT NULL;
B.
SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders;
C.
SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders GROUP BY
sales_rep_id;
D.
SELECT sales_rep_id, COUNT(order_id) total_orders FROM orders GROUP BY
sales_rep_id, total_orders;
Explanation: