Consulta compleja entre dos select

[manete]

Hola a todos, tengo la siguiente consulta:

(SELECT octavosa1 AS resul, COUNT(octavosa1) AS numero FROM resultadopollamundialeras GROUP BY octavosa1 HAVING COUNT(octavosa1) >0)
UNION ALL
(SELECT octavosa2 AS resul, COUNT(octavosa2) AS numero FROM resultadopollamundialeras GROUP BY octavosa2 HAVING COUNT(octavosa2) >0)

pero necesito que se agrupen y que se sumen los count respectivos de cada resul.

porfavor si alguien lo puede resolver, se lo agradeceria!

slds!
matias

[quimfv]

Código MySQL:

SELECT sbc.resul, SUM(sbc.numero) as Tnumero
FROM ((SELECT octavosa1 AS resul, COUNT(octavosa1) AS numero FROM resultadopollamundialeras GROUP BY octavosa1 HAVING COUNT(octavosa1) >0)
UNION ALL
(SELECT octavosa2 AS resul, COUNT(octavosa2) AS numero FROM resultadopollamundialeras GROUP BY octavosa2 HAVING COUNT(octavosa2) >0)) as sbc
GROUP BY sbc.resul;
 

Era esto?