t100: route_year

Custom SQL query (hide)

SELECT
  year,
  printf('%02d', month) AS month,
  origin_city_name,
  dest_city_name,
  c.name AS carrier,
  a.name AS aircraft,
  departures_performed AS deps,
  departures_scheduled AS scheduled,
  payload AS total_payload,
  seats AS total_seats,
  passengers AS total_passengers,
  ROUND((1.0 * passengers) / seats * 100, 1) AS load_factor,
  freight AS total_freight,
  ramp_to_ramp AS total_ramp_time,
  air_time AS total_air_time
FROM t100 AS t
  JOIN aircraft_types a ON t.aircraft_type = a.AC_TYPEID
  JOIN carriers c ON t.carrier_entity = c.CARRIER_ENTITY
WHERE
  origin = :origin
  AND dest = :dest
  AND year = :year
ORDER BY
  month ASC,
  a.name ASC,
  c.name ASC,
  total_passengers DESC