Consulta con totales algo especial

[Libras]

Código MySQL:

SELECT "Grupo1" AS Grupo, Sum(datosPlayers.respuesta) AS Total
FROM datosPlayers
WHERE datosPlayers.idPregunta)="1"
GROUP BY "Grupo1"
union
SELECT "Grupo1" AS Grupo, Sum(datosPlayers.respuesta) AS Total
FROM datosPlayers
WHERE datosPlayers.idPregunta)="2"
GROUP BY "Grupo1"
.
.
.
SELECT "Grupo1" AS Grupo, Sum(datosPlayers.respuesta) AS Total
FROM datosPlayers
WHERE datosPlayers.idPregunta)="N"
GROUP BY "Grupo1"