Problema consulta SQL sobre estadística
Tengo tabla resultados con campos fecha, n1, n2, n3, n4, n5 quiero sacar las parejas que mas se repiten de los últimos diez sorteos, tengo las consultas de abajo por simplificar pero solamente me suma si coinciden en la misma columna si no está en la misma columna no los suma, alguien me puede ayudar, gracias.
select count(*) as veces, n1 as num1,n2 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n1,n2 order by 1 desc,2,3 union all select count(*) as veces, n1 as num1,n3 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n1,n3 order by 1 desc,2,3 union all select count(*) as veces, n1 as num1,n4 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n1,n4 order by 1 desc,2,3 union all select count(*) as veces, n1 as num1,n5 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n1,n5 order by 1 desc,2,3 union all select count(*) as veces, n2 as num1,n3 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n2,n3 order by 1 desc,2,3 union all select count(*) as veces, n2 as num1,n4 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n2,n4 order by 1 desc,2,3 union all select count(*) as veces, n2 as num1,n5 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n2,n5 order by 1 desc,2,3 union all select count(*) as veces, n3 as num1,n4 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n3,n4 order by 1 desc,2,3 union all select count(*) as veces, n3 as num1,n5 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n3,n5 order by 1 desc,2,3 union all select count(*) as veces, n4 as num1,n5 as num2 from resultados where fecha in (select top 10 fecha from resultados order by fecha desc) group by n4,n5 order by 1 desc,2,3;
