C_DS_42 · Question #39
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables. Use the sum function to calculate the…
The correct answer is B. In the Query Editor , select the Group By tab. C. In the Schema In column, select the ORDERID field from the ORDER_DETAILS table and drag it D. Close the Editor. See the full explanation below for the reasoning.
Question
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables. Use the sum function to calculate the total value of orders in the Order_Details table. How to Now that the expression can calculate the total of the order values, make it possible for the Query to begin at the first order through the end of the records in the table by using the Group By tab?
Options
- AOn the Mapping tab of the TOTAL_VALUE column, enter the expression:
- BIn the Query Editor , select the Group By tab.
- CIn the Schema In column, select the ORDERID field from the ORDER_DETAILS table and drag it
- DClose the Editor.
How the community answered
(33 responses)- A21% (7)
- B79% (26)
Community Discussion
No community discussion yet for this question.