You have a flights table with origin, destination, departure_time, and arrival_time. Write a query to find all possible two-leg journeys from city A to city C (via any intermediate city B) where the layover is between 1 and 4 hours.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

You have a flights table with origin, destination, departure_time, and arrival_time. Write a query to find all possible two-leg journeys from city A to city C (via any intermediate city B) where the layover is between 1 and 4 hours.

Practice more