Consulta compleja entre dos select

[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?