Virtual Table Rank Optimization

Sample data does not show the issue so I share all database's photo.
Bağlantı Tablosu2 (Connection Table): Represent flight data Cr: Carrier Code, FlightNumbers, Toplam Uçuş Süresi means total flight duration, DDS means Departure-Arrival passenger data.

TK Tablosu Gidiş: Data shows that second leg of our virtual flight. Virtual flight is first leg in that case

TK Tablosu Dönüş: Data shows that first leg of our virtual flight.Virtual flight is second leg in that case

This is matrix table that every 5 minutes of the week.

Blok Süre Gidiş: is the duration of our virtual flight first way

Blok Süre Dönüş: is the duration of our virtual flight second way

Yatı süresi: Means waiting duration of between first and second flight

And my window:

My main goal is I select an airport and Duration of first and second leg flight. With this for every 5 minutes of departing and for 5 minutes of waiting, I want to calculate rank of my virtual flight.

Thank you