I have a large dataset spanning several years and I am having problems getting a string such as "53-2016" (week 53 in 2016).

My query is:

```
SELECT 
  date,
  DATE_FORMAT(date, "%v-%Y") AS week,      
FROM myTable
GROUP BY week
ORDER BY date;

```

Using this query I get two rows where I would like to only have one. 

This happens because of `GROUP BY week`. At the end of 2015 the dates: 28-31 of December are added to week 53-2015 where the rest of the week (1-3 of January) are added to a row called 53-2016.

Is there any way that I can add the first three days of January to the group 53-2015?