MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE de_data(id varchar(6),right_score int ,    left_score int)
INSERT INTO de_data VALUES ('037629', 1,1),('037629', 3,1),('037629', 1,3),('037629', 3,3),('037629', 2,2)
,('037629', 1,1),('037629', 2,2)
SELECT 
    right_score,
    left_score,
    CASE
        WHEN right_score < 3 THEN right_score = 1
        WHEN right_score >= 3 THEN right_score = 0
    END AS r_result,
    CASE
        WHEN left_score < 3 THEN left_score = 1
        WHEN left_score >= 3 THEN left_score = 0
    END AS l_result
FROM
    de_data
WHERE
    id = 037629


right_score
left_score
r_result
l_result


1
1
1
1

3
1
0
1

1
3
1
0

3
3
0
0

2
2
0
0

1
1
1
1

2
2
0
0


SELECT 
    right_score,
    left_score,
    CASE
        WHEN right_score < 3 THEN  1
        WHEN right_score >= 3 THEN  0
    END AS r_result,
    CASE
        WHEN left_score < 3 THEN  1
        WHEN left_score >= 3 THEN  0
    END AS l_result
FROM
    de_data
WHERE
    id = 037629


right_score
left_score
r_result
l_result


1
1
1
1

3
1
0
1

1
3
1
0

3
3
0
0

2
2
1
1

1
1
1
1

2
2
1
1