Pregunta de entrevista de CARVANA

SQL question with the lag lead function..