MySQL 8.0

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

with BaseData as (
SELECT 1 Runner, 2015 YR, -8.29 value UNION ALL
SELECT 1 Runner, 2016 YR, -8.29 value UNION ALL
SELECT 1 Runner, 2017 YR, -8.29 value UNION ALL
SELECT 1 Runner, 2018 YR, -8.29 value UNION ALL
SELECT 1 Runner, 2019 YR, -8.29 value UNION ALL
SELECT 2 Runner, 2015 YR, 1 value UNION ALL
SELECT 2 Runner, 2016 YR, 1 value UNION ALL
SELECT 2 Runner, 2017 YR, 1 value UNION ALL
SELECT 2 Runner, 2018 YR, 1 value UNION ALL
SELECT 2 Runner, 2019 YR, 1 value UNION ALL
SELECT 3 Runner, 2015 YR, 1 value UNION ALL
SELECT 3 Runner, 2016 YR, -1 value UNION ALL
SELECT 3 Runner, 2017 YR, -1 value UNION ALL
SELECT 3 Runner, 2018 YR, -1 value UNION ALL
SELECT 3 Runner, 2019 YR, -1 value UNION ALL
SELECT 4 Runner, 2015 YR, -1 value UNION ALL
SELECT 4 Runner, 2016 YR, 1 value UNION ALL
SELECT 4 Runner, 2017 YR, 1 value UNION ALL
SELECT 4 Runner, 2018 YR, 1 value UNION ALL
SELECT 4 Runner, 2019 YR, 1 value),
CTE as (
SELECT A.Runner RUN1, B.Runner RUN2,
sum(case when A.value>0 and A.Runner = B.Runner then 1 else 0 end)  as isValidYear,
       count(A.YR) TotalYears,
       sum(case when A.Runner=B.Runner then A.value else 0 end) as TotalValue,
       sum(case when A.runner<> B.Runner and (A.Value>0 OR  B.Value > 0) then 1 end) as isValid2PersonYR
FROM BaseData A
CROSS JOIN BaseData B
WHERE A.YR=B.YR
GROUP BY A.Runner, B.Runner
Order by A.Runner)
SELECT RUN1, Run2, sum(isValidYear) SumIsvalidYear, Sum(isValid2PersonYR) SumIsvalid2PersonYr, TotalYears
FROM CTE
Group by Run1, Run2, TotalYears
HAVING SumisValidYear = Totalyears OR SumisValid2personYR=TotalYears
ORDER BY SUMISVALID2PERSONYR

RUN1	Run2	SumIsvalidYear	SumIsvalid2PersonYr	TotalYears
2	2	5	null	5
1	2	0	5	5
2	1	0	5	5
2	3	0	5	5
2	4	0	5	5
3	2	0	5	5
3	4	0	5	5
4	2	0	5	5
4	3	0	5	5