I have a table with a row for each events for a user. I want to retrieve every user who got 2 or more events in **the same week** *(with up to 7 days between them)*.

Event Table :

```
id   -   user_id   -   date
 1   -       1     -   2015/04/02
 2   -       1     -   2015/04/05
 3   -       1     -   2015/09/12
 4   -      14     -   2016/01/21
 5   -      14     -   2016/02/18

```

So the expected results should be

```
user_id   -   count(date in same week)
 1        -         2

```

The user\_id 14 should not be in results, because its events are not in the same week.

Does someone know how to do it entirely in MySQL ?