大佬,请问算留存率是否需要SELECT AVG(COALESCE(diff, 0)) AS avg_diff,因为avg会忽略diff是null的行,所以算不对diff=1占总体的比例