Congratulations! You just learned about Conditional Aggregates in SQL. What can we generalize so far?
- Conditional Aggregates are aggregate functions the compute a result set based on a given set of conditions.
NULL can be used to denote an empty field value
CASE statements allow for custom classification of data
CASE statements can be used inside aggregates (like
COUNT()) to provide filtered measures