Roku Interview Question

Basic sql using aggregations, window functions like lead,lag, row number etc