Domanda di colloquio di Expedia Group

Standard SQL question with window function and join. Machine learning problem is to predict whether the person is going to cancel the reservation.