title: Get the Last 4 Weeks Data as averages in sqlserver 2008
body: <p>How to get Last 4 weeks of data as an average in sqlserver 2008.</p>
  
  <p>i have the data like 1st week with 4 records - O/P should be like average of these four records week wise similarly i need it for one month as four week of data i.e four records.
   please suggest me the sqlserver query.</p>