ABC interview question

Sql windows functions and rolling avg