SELECT month, year, SUM(lateAircraft) AS sumLateAircraft, SUM(weather) AS sumWeather, SUM(carrier) AS sumCarrier ,
SUM(security) AS sumSecurity, SUM(total) as sumTotal, SUM(nationalAviationSystem) sumNationalAviationSystem,
carrierCode, carrierName, airportCode, airportName FROM(
SELECT month, year, lateAircraft, weather, carrier, security, total, carrierCode, carrierName, minutesDelayedStatistics.nationalAviationSystem,
airportCode, airportName
 FROM (minutesDelayedStatistics JOIN
(SELECT month, year, minutesDelayedId, carrierCode, carrierName, statisticId, airportCode, airportName FROM (
statistics JOIN (
SELECT carrierCode, name as carrierName, statisticId, month, year, airportName, airportCode FROM (carriers JOIN (SELECT month, year, carrierCode, statisticId, airports.name as airportName, airportCode FROM (general JOIN airports ON
general.airportCode = airports.code)
WHERE
month = 6 AND year = 2003 AND airportCode = 'ATL') ON carriers.code = carrierCode))
ON statistics.id = statisticId))
ON minutesDelayedId = minutesDelayedStatistics.id))
GROUP BY carrierCode, month, year;