SELECT res.aircraft_code,
       res.actual_arrival,
       sum(res.tickets_count)
       OVER (PARTITION BY res.aircraft_code
            ORDER BY res.actual_arrival)

FROM (SELECT f.flight_id,
             f.status,
             f.aircraft_code,
             f.actual_arrival,
             (CASE WHEN tf.count is NULL THEN 0
                ELSE tf.count
              END) AS tickets_count

      FROM flights AS f

      LEFT JOIN (SELECT flight_id, count(*)
            FROM ticket_flights
            GROUP BY flight_id) AS tf
      ON f.flight_id = tf.flight_id

      WHERE f.status='Arrived'
        AND (f.aircraft_code='319'
            OR f.aircraft_code='773')
        AND f.actual_arrival >= (bookings.now() - interval '15 hours')
        AND f.actual_arrival < (bookings.now() + interval '9 hours')

      ORDER BY f.aircraft_code, f.actual_arrival) AS res

ORDER BY res.aircraft_code, res.actual_arrival DESC;