Oracle interview question

Sliding window based question was asked