Discuss some of the calculations that can be created using aggregate queries. What kinds of decisions can these calculations help managers make?
What will be an ideal response?
Since aggregate queries group identical values into a single record, managers can easily roll up multiple transactions into meaningful groups, like departments, categories, subjects, and so on. The summary data can help managers get an overall view of how an area or department is doing without worrying about the details. Common aggregate functions include Sum, Avg, Count, Max, Min, StDev, and Var. When the Where function is used, criteria can be added to the query that is not included in the grouping. When the Expression function is used, a new calculation can be included in the query to calculate things like total revenue or total expenses.
You might also like to view...
The Step Into debugger command can be used to __________.
a) return from the method to the caller b) modify the code at execution time to correct a logic error c) execute the code statements in a different order to locate a bug d) view the code for a called method as it executes
What can you do if Lightroom won’t let you expand more than one panel at a time in either of the side panel groups?
What will be an ideal response?
When appropriate, specialized ____ classes provide an elegant way for you to handle error situations.
A. Exception B. Error C. Constructor D. Event
All user agents render text-formatting elements (like the element) in the same way.
Answer the following statement true (T) or false (F)