Prev Question
Next Question

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

5a104926df69c - Which statement would achieve this purpose?

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;

Prev Question
Next Question

Leave a Reply

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