Dias + 7!

[death_nemesis]

este codigo tengo yo es en SQL Server pero lo puedes modificar aqui te calcula el dia actual - 7 dias

select sum(bol_pag)as total,datename(WEEKDAY,bol_fec)as SEMANA from boleta where bol_fec BETWEEN DATEADD(DD, -7, GETDATE()) AND GETDATE()
group by datename(WEEKDAY,bol_fec),datepart(WEEKDAY,bol_fec ) order by datepart(WEEKDAY,bol_fec)