Task $1$

You are given two tables, flights and airports, with the following structure:

and

Each row in the table flights contains information about a flight: code of

departure port $($start$\_$port$)$ and code of destination port $($end$\_$port$).$

Each row in the table airports contains information about an airport: the

city name $($city$\_$name$)$ and the port code $($port$\_$code$).$ Each port$\_$code is

assigned to at most one airport.

Write an SQL query that finds all cities through which a fight from New York

to Tokyo may pass if the passenger wants to make exaetly one change of

flights.

$..........$