Building a Basic Aggregation: Test your skills

You are building an aggregate statement in IntelliShell. You want to include the collation option in the statement. Where do you add the option within the statement?

You are building an aggregate statement in IntelliShell. The statement will aggregate data in the customers collection. You want to filter out all customers except those who live in Georgia. Which aggregate method do you use when defining your first stage?

You are building an aggregate statement in IntelliShell. The statement will aggregate data in the customers collection. You want to group the data by the package field and find the average number of transactions per package. Which $group expression should you use?

You are building an aggregate statement in IntelliShell. The last stage in the pipeline uses the $sort operator to sort the pipeline documents in descending order, based on the total column. Which argument should you use to specify the sort order?

You are building an aggregate statement in IntelliShell. You want to be able to write data to temporary files on disk when running the statement. Which option should you include in your statement?