Which statement would achieve this purpose?

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?

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 ”
HAVING COUNT(customer_id) > 10;

B.
SELECT sales_rep_id, COUNT(customer_id) “Total”
FROM orders ”
WHERE COUNT(customer_id) > 10
GROUP BY sales_rep_id;

C.
SELECT sales_rep_id, COUNT(customer_id) “Total”
FROM orders ”
GROUP BY sales_rep_id
HAVING total > 10;

D.
SELECT sales_rep_id, COUNT(customer_id) “Total”
FROM orders ”
GROUP BY sales_rep_id
HAVING COUNT(customer_id) > 10;



Leave a Reply 0

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