Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from
- (select f.flight_id , f.departure_time, f.arrival_time, a.airport_name as origin, t.airport_name as destination
- from Flights as f
- inner join airports as a on f.origin_airport_id = a.airport_id
- inner join airports as t on f.destination_airport_id = t.airport_id
- where f.`status` = 'Departing'
- order by f.departure_time desc
- limit 5) as q
- order by q.departure_time, q.flight_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement