Lab
Lab #12: Selective Aggregation
Learn how to use the CASE
operator with aggregation functions to transform and report data. This type of approach is known as selective aggregation.
- Lab
- Description
- Help Section
- Instructions
Objectives
You learn how to use the CASE
and SUM operators to return a selectively aggregated result set.
Business Scenario
Business analysts write reports that qualify financial transactions by month, quarter, and year. You typically report assets as credits and debits. Debits are shown as positive numbers and debits are shown as negative numbers.