I have my query that shows me my data in this way
select
Nombre,
Deporte,
sum(Ganar),
sum(perder)
from Tabla
where CodPersona = 777
group by Nombre, deporte
the query shows me the sums of the two sports and repeats the results for both the same value
What I should show would be like this