Rewrite Aggregate Functions Using if Expressions for Performance Improvement
Official CH changelog text
Rewrite aggregate functions with if expression as argument when logically equivalent. For example, avg(if(cond, col, null)) can be rewritten to avgIf(cond, col). It is helpful in performance. #44730 (李扬).