Interview Query

Total Time in Flight

Have you seen this question before?

Let’s say you work in air traffic control. You are given the table below containing information on flights between two cities.

Write a query to find out how much time, in minutes (rounded down), each plane spent in the air each day.

Note: Both cities are in the same time zone, so you do not need to worry about converting time zones.

flights table



Columns Type
destination_location VARCHAR
source_location VARCHAR
plane_id INTEGER
flight_start DATETIME
flight_end DATETIME


Columns Type
plane_id INTEGER
calendar_day VARCHAR
time_in_min INTEGER

Please give calendar_day in the format YYYY-MM-DD

Next question: Distance Traveled
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query