MySQL group
How to group by week in MySQL? https://stackoverflow.com/questions/1736010/how-to-group-by-week-in-mysql
MySQL Query to select data from last week?
https://stackoverflow.com/questions/6089960/mysql-query-to-select-data-from-last-week
SELECT *FROM yourTableName WHERE YEARWEEK(yourDateColumnName) = YEARWEEK(NOW());
https://www.tutorialspoint.com/how-to-query-mysql-on-the-current-week