I can't figure out how to calculate departures that follow each other with a break of at least 5 minutes?

Question

PostgreSQL

There is a flight table, from which you need to select the number of flights that followed EACH OTHER with a break of at least 5 minutes. In this case, the airport of departure departure_airport must be equal to SVO.


It's not clear to me how you can select lines while comparing them with other lines so that the departure time differs by at least 5 minutes?

Answer 1

window function.