Conditional Aggregates


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 SUM() and COUNT()) to provide filtered measures
Community Forums
Get help and ask questions in the Codecademy Forums
Report a Bug
If you see a bug or any other issue with this page, please report it here.