Beriefly explain, in your own words, different ways to process an aggregate query. For each processing option, obtain the query processing cost. Here is an example of an aggregate query:

select dept-name, avg(salary)

from instructor

group by dept-name