Question d’entretien chez Machinify

Solve an SQL question, the answer required LEAD and LAG