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.
NULLcan be used to denote an empty field value
CASEstatements allow for custom classification of data
CASEstatements can be used inside aggregates (like
COUNT()) to provide filtered measures