View the Exhibit and examine the description of the ORDERS table.Your manager asked you to get the SALES_REP_ID and the
Posted: Wed Jun 07, 2023 6:11 am
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;
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;