when does it use scalar functions over aggregate functions?
PLEASE ANSWER THIS PROPERLY OR ELSE I WILL REPORT YOU