Write a SQL query using window functions to calculate each student's rolling average test score over time and compare it to their overall average.
