Taking aggregations from specific items in a dataset can easily be achieved by using simple
IF statements inside a
AVG() or any function for that matter.
Just remember to use
NULL as the false value as using
AVG() will mess up your results.
Created: Oct 3rd 2020