View the Exhibit and examine the description of the ORDERS table. The orders in the
ORDERS table are placed through sales representatives only. You are given the task to get
the SALES_REP_ID from the ORDERS table of those sales representatives who have
successfully referred more than 10 customers. Which statement would achieve this
purpose?
A.
SELECT sales_rep_id, COUNT(customer_id) “Total” FROM orders ” GROUP BY
sales_rep_id HAVING COUNT(customer_id) > 10;
B.
SELECT sales_rep_id, COUNT(customer_id) “Total” FROM orders ” HAVING
COUNT(customer_id) > 10;
C.
SELECT sales_rep_id, COUNT(customer_id) “Total” FROM orders ” WHERE
COUNT(customer_id) > 10 GROUP BY sales_rep_id;
D.
SELECT sales_rep_id, COUNT(customer_id) “Total” FROM orders ” GROUP BY
sales_rep_id HAVING total > 10;