返回平均存款，在sql server中退出最后八周

i want to write a simple query that will return me average deposits and bets from MyTable, but for last eight weeks starting from today and to have also in select first day of that week in format dd/mmi want to write a simple query that will return