select Pedacos.CodVoo, count(Pedacos.CodVoo) as Num_Rotas, (select rota3.Origem
															from Rota rota3
															where rota3.CodRota = Ori.Minimo ) as Origem, (select rota4.Destino
																								 from Rota rota4
																								 where rota4.CodRota = Dest.Maximo ) as Destino
from (select voo2.CodVoo, rota2.Origem, rota2.Destino
									   from Voo voo2, Rota rota2
									   where voo2.CodVoo = rota2.CodVoo) as Pedacos, (select voo2.CodVoo, min(rota2.CodRota) as Minimo
																					  from Voo voo2, Rota rota2
																					  where voo2.CodVoo = rota2.CodVoo
																					  group by voo2.CodVoo) as Ori, (select voo2.CodVoo, max(rota2.CodRota) as Maximo
																													 from Voo voo2, Rota rota2
																													 where voo2.CodVoo = rota2.CodVoo
																													 group by voo2.CodVoo) as Dest
where Ori.CodVoo = Dest.CodVoo
and Ori.Minimo < Dest.Maximo
and Pedacos.CodVoo = Ori.CodVoo
group by Pedacos.CodVoo, Ori.Minimo, Dest.Maximo