Código MySQL:
Ver original Sum(numArrivals
) as Arrivals
, Sum(numDep
) as Departures
a.iataCompanyCode
as company
, count(a.idArrivalFlight
) as numArrivals
, from `aodb`.
`arrivalFlight` a
where a.iataCompanyCode
in ('SPP','IB') and a.scheduledTime
between '2011-01-01 00:00:00' and '2011-09-01 00:00:00' count(b.idDepartureFlight
) as numDep
from `aodb`.
`departureflight` b
where b.iataCompanyCode
in ('SPP','IB') and b.scheduledTime
between '2011-01-01 00:00:00' and '2011-09-01 00:00:00' group by b.iataCompanyCode
,numArrivals
)
Preguntate si esos DISTINCT son necesarios... puesto que tienen su coste...