Query Run
set @lastweek = curdate() - interval dayofweek(curdate())+6 day; set... 8 years ago
set @lastweek = curdate() - interval dayofweek(curdate())+6 day; set... 8 years ago