t100: top_airports

Custom SQL query (hide)

WITH ranked AS (
  SELECT origin, origin_city_name, deps, seats, passengers, freight,
    RANK() OVER (ORDER BY passengers DESC) AS by_passengers,
    RANK() OVER (ORDER BY deps DESC) AS by_deps,
    RANK() OVER (ORDER BY seats DESC) AS by_seats,
    RANK() OVER (ORDER BY freight DESC) AS by_freight
  FROM airport_year_totals
  WHERE year = CAST(:year AS integer)
    AND origin_wac BETWEEN 1 AND 93
)
SELECT origin, origin_city_name, deps, seats, passengers, freight
FROM ranked
WHERE by_passengers <= 20 OR by_deps <= 20 OR by_seats <= 20 OR by_freight <= 20
ORDER BY passengers DESC, origin