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?

Question

Accepted Answer

D. SELECT sales_rep_id, COUNT(customer_id) "Total"

Answer

A. SELECT sales_rep_id, COUNT(customer_id)"Total"

Answer

B. SELECT sales_rep_id, COUNT(customer_id) "Total"

Answer

C. SELECT sales_rep_id, COUNT(customer_id) "Total"

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…

Question

Exhibit

Options

How the community answered

Community Discussion