Glossary: SQL Beyond the Basics
Conditional aggregation
Putting a CASE inside an aggregate such as SUM or COUNT so it only counts the rows you choose. It is how you build pivots, like cafés and online customers side by side.
Glossary: SQL Beyond the Basics
Putting a CASE inside an aggregate such as SUM or COUNT so it only counts the rows you choose. It is how you build pivots, like cafés and online customers side by side.