CARVANA Interview Question

SQL question with the lag lead function..