Group Aggregate Quiz

What you'll be asked

1. Which of the following SQL clauses is primarily used to group rows that have the same values into summary rows?
2. If you need to filter the results of an aggregation (e.g., only show categories where the total sales exceed $10,000), which clause should you use?
3. In a data transformation pipeline, what is the primary purpose of applying an aggregate function like SUM() or AVG() during the 'Load' phase?
4. When performing a group aggregate, what happens to non-aggregated columns that are not included in the GROUP BY clause?
5. You are aggregating sales data by 'Region' and 'Product_Category'. You want to calculate the total revenue, but you must exclude transactions with a status of 'Cancelled' before the calculation. Which approach is most efficient?

Answers and explanations come after you submit.