Expedia Group Interview Question

SQL window function, lag and lead