Aggregate. Computes the y-intercept of the linear regression line that best fits the dependent and independent variables.
regr_intercept ( dependent-expression, independent-expression )
dependent-expression | The variable that is affected by the independent variable. The expression accepts numeric datatypes, except timestamp, bigdatetime, and interval. |
independent-expression | The variable that influences the outcome. The expression accepts numeric datatypes, except timestamp, bigdatetime, and interval. |
avg( x ) - regr_slope( x, y ) * avg( y )