Given is below record in `user_score` table where each user can have multiple score, user will diff user id can have same name and role. How to fetch average score along with `user_id`, `role` and `name`. I want to group by `user_id`.

So for my below table I am expecting result as:

```
Name   Role  Score  user_id
Jack   CEO     6      123
Jack   CEO     2      456
Tony   Dev     5      234
Sham    QA     3      678

```

**user\_score table data :**

```
id     name    role     score    user_id
1      Jack    CEO       4        123
2      Jack    CEO       8        123
3      Tony    Dev       9        234
4      Jack    CEO       2        456
5      Tony    Dev       1        234
6      Sham    QA        3        678

```