For example, assign “A” for scores above 90, “B” for scores between 80 and 90, and so on. Logical Tests in Aggregation: Embed logical tests directly into functions like `SUM` or `AVERAGE ...