ROUND((변화율 볼 수치 - 기준 수치)/기준 수치,반올림자릿수)
EX)
ROUND((c.average - c.control_average)/c.control_average,4) AS rate_lift
ROUND(STDDEV(칼럼명),반올림자릿수)
EX)
ROUND(STDDEV(a.metric),4) AS stdev
EX)
ROUND((c.average - c.control_average) /
SQRT((c.variance/c.users) + (c.control_variance/c.control_users))
,4) AS t_stat
(1 - COALESCE(nd.value,1))*2 AS p_value
ABS
절댓값
ROUND
반올림
SQRT
제곱근
STDDEV
표준편차
COALESCE
NULL이 아닌 첫 번째 값을 반환