Aggregate. Computes the average of the dependent variable of the regression line.
regr_avgy ( dependent-expression , independent-expression )
dependent-expression | The variable that is affected by the independent variable. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
independent-expression | The variable that influences the outcome. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
avg( x )