MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE src_table (x INT, y INT);
INSERT INTO src_table VALUES
(106,	7),
(100,	27),
(86,	2),
(101,	50),
(99,	28),
(103,	29),
(97,	20),
(113,	12),
(112,	6),
(110,	17);
SELECT * FROM src_table;


x
y


106
7

100
27

86
2

101
50

99
28

103
29

97
20

113
12

112
6

110
17


WITH 
cte1 AS ( SELECT x,
                 y,
                 CAST(RANK() OVER(ORDER BY x) AS SIGNED) as ranked_x,
                 CAST(RANK() OVER(ORDER BY y) AS SIGNED) as ranked_y
          FROM src_table ),
cte2 AS ( SELECT x,
                 y,
                 ranked_x,
                 ranked_y,
                 ranked_x - ranked_y AS di,
                 (ranked_x - ranked_y) * (ranked_x - ranked_y) as di2
          FROM cte1 )
SELECT * FROM cte2;


x
y
ranked_x
ranked_y
di
di2


86
2
1
1
0
0

112
6
9
2
7
49

106
7
7
3
4
16

113
12
10
4
6
36

110
17
8
5
3
9

97
20
2
6
-4
16

100
27
4
7
-3
9

99
28
3
8
-5
25

103
29
6
9
-3
9

101
50
5
10
-5
25


WITH 
cte1 AS ( SELECT x,
                 y,
                 CAST(RANK() OVER(ORDER BY x) AS SIGNED) as ranked_x,
                 CAST(RANK() OVER(ORDER BY y) AS SIGNED) as ranked_y
          FROM src_table ),
cte2 AS ( SELECT x,
                 y,
                 ranked_x,
                 ranked_y,
                 ranked_x - ranked_y AS di,
                 (ranked_x - ranked_y) * (ranked_x - ranked_y) as di2
          FROM cte1 )
SELECT 1 - 6 * SUM(di2) / COUNT(*) / (COUNT(*) * COUNT(*) - 1) AS srcc
FROM cte2;


srcc


-0.17575758


WITH 
cte AS ( SELECT POW((CAST(RANK() OVER(ORDER BY x) AS SIGNED) - CAST(RANK() OVER(ORDER BY y) AS SIGNED)), 2) as di2
         FROM src_table )
SELECT 1 - 6 * SUM(di2) / COUNT(*) / (COUNT(*) * COUNT(*) - 1) AS srcc
FROM cte;


srcc


-0.17575757575757578

x	y	ranked_x	ranked_y	di	di2
86	2	1	1	0	0
112	6	9	2	7	49
106	7	7	3	4	16
113	12	10	4	6	36
110	17	8	5	3	9
97	20	2	6	-4	16
100	27	4	7	-3	9
99	28	3	8	-5	25
103	29	6	9	-3	9
101	50	5	10	-5	25

x	y	ranked_x	ranked_y	di	di2
86	2	1	1	0	0
112	6	9	2	7	49
106	7	7	3	4	16
113	12	10	4	6	36
110	17	8	5	3	9
97	20	2	6	-4	16
100	27	4	7	-3	9
99	28	3	8	-5	25
103	29	6	9	-3	9
101	50	5	10	-5	25

x	y	ranked_x	ranked_y	di	di2
86	2	1	1	0	0
112	6	9	2	7	49
106	7	7	3	4	16
113	12	10	4	6	36
110	17	8	5	3	9
97	20	2	6	-4	16
100	27	4	7	-3	9
99	28	3	8	-5	25
103	29	6	9	-3	9
101	50	5	10	-5	25