1SELECT
2 slope
3 , y_bar_max - x_bar_max * slope AS intercept
4FROM (
5 SELECT
6 SUM((x - x_bar) * (y - y_bar)) / SUM((x - x_bar) * (x - x_bar)) AS slope
7 , MAX(x_bar) AS x_bar_max
8 , MAX(y_bar) AS y_bar_max
9 FROM (
10 SELECT
11 x
12 , y
13 , AVG(x) OVER () AS x_bar
14 , AVG(y) OVER () AS y_bar
15 FROM data
16 )
17)