Roku interview question

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