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
GROUP BY sales_rep_id;
B.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders
GROUP BY sales_rep_id, total_orders;
C.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders;
D.
SELECT sales_rep_id, COUNT(order_id) total_orders
FROM orders
WHERE sales_rep_id IS NOT NULL;
This was a bit too easy… is this for SQL expert exam?