This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
Given the following flight timetable. The table specifies 3 flights (flight_id) that departure Ben Gurion International Airport. For each of these flights, the destinations (flight_dest) are indicated by their order. For example, the first connection of flight no. 1 is in Bucharest, then Rome, and the final destination is Warsaw.
In addition, this table displays the status (arrival_desc) of each flight. For example, flight no. 2 has already passed Zurich and Madrid and is now on its way to Boston, flight no. 3 left Munich, passed through Frankfurt, and arrived at its final destination in Budapest.
CREATE TABLE flights (flight_id int, flight_dest int, flight_dest_name varchar(25), arrival_desc varchar(25)) GO