Altman Solon Interview Question

SQL PostGres - LAG() Function. Basic consulting case studies might help.