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.