SELECT
lateAircraft AS numbersLateAircraft,
weather AS numbersWeather,
security AS numbersSecurity,
nationalAviationSystem AS numberNationalAviationSystem,
carrier AS numberCarrier,
minutesLateAircraft,
minutesWeater,
minutesCarrier,
minutesSecurity,
minutesTotal,
minutesNationalAviationSystem,
flightsCancelled,
flightsCancelled,
flightsTotal,
flightsDelayed,
flightsDiverted,
numberOfDelaysId,
minutesDelayedId,
carrierCode,
carrierName,
airportCode,
airportName
FROM (numberOfDelaysStatistics JOIN
(SELECT
lateAircraft AS minutesLateAircraft,
weather AS minutesWeater,
carrier AS minutesCarrier,
security AS minutesSecurity,
total AS minutesTotal,
nationalAviationSystem AS minutesNationalAviationSystem,
flightsCancelled,
flightsCancelled,
flightsTotal,
flightsDelayed,
flightsDiverted,
numberOfDelaysId,
minutesDelayedId,
carrierCode,
carrierName,
airportCode,
airportName
FROM (minutesDelayedStatistics JOIN
(SELECT
cancelled AS flightsCancelled,
onTime AS flightsCancelled,
total AS flightsTotal,
delayed AS flightsDelayed,
diverted AS flightsDiverted,
numberOfDelaysId,
minutesDelayedId,
carrierCode,
carrierName,
airportCode,
airportName
FROM (flightStatistics JOIN
(SELECT * FROM (statistics JOIN
(SELECT carrierCode,
name AS carrierName,
airportCode,
airportName,
statisticId FROM (carriers JOIN
(SELECT name AS airportName,
airportCode, statisticId, carrierCode
FROM (airports JOIN
(SELECT *
FROM general
WHERE carrierCode='AA' AND airportCode='ATL')
ON airportCode = airports.code))
ON carrierCode = carriers.code))
ON statistics.id = statisticId))
ON flightStatistics.id = flightsId))
ON minutesDelayedStatistics.id = minutesDelayedId))
ON numberOfDelaysStatistics.id = numberOfDelaysId);