Oracle
1Z0-047 · Question #6
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…
The correct answer is A. SELECT sales_rep_id, COUNT(order_id) total_orders. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT sales_rep_id, COUNT(order_id) total_orders
- BSELECT sales_rep_id, COUNT(order_id) total_orders
- CSELECT sales_rep_id, COUNT(order_id) total_orders
- DSELECT sales_rep_id, COUNT(order_id) total_orders
How the community answered
(34 responses)- A76% (26)
- B3% (1)
- C15% (5)
- D6% (2)
Community Discussion
No community discussion yet for this question.