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