group columns in mysql

Question

Have these Insert in the table

I would like an sql me returns the total points of the type team:

time - points

Uruguai - 9

Russia - 6

Rabia - 3

Gito - 0

Answer 1

This code solves:

SELECT TIME, SUM(J.PONTOS) AS PONTOS FROM (
   SELECT TIME1 AS TIME, PONTOSTIME1 AS PONTOS
      FROM JOGOS
   UNION ALL
   SELECT TIME2 AS TIME, PONTOSTIME2 AS PONTOS
      FROM JOGOS) AS J
GROUP BY TIME
ORDER BY PONTOS DESC

Results in:

TIME    PONTOS
uruguai 9
russia  6
arabia  3
egito   0

See working in http://sqlfiddle.com/#! 9/292934/25

Answer 2

See if it suits you:

with pontuacao_times as(
select time1       as time
      ,pontostime1 as pontos
  from Sua_tabela
union all
select time2       as time
      ,pontostime2 as pontos
  from Sua_tabela)
select time
      ,pontos 
  from pontucao_times
 group by time, pontos;