Okay, I am a total newbie stuck with the following task.
I have one table, that looks like this:
| id | name | rating | date |
What I am trying to do is gettin an output showing which 'name' has the best 'rating' based on months,
showing a top 5 of those users. The value in the 'rating' row is from 1-5.
So first I have to count the sum of the 'rating' for each 'name', and then I have to put those names in a list,
ordered by the one with the biggest value.
1 : user A , 55 points
2 : user B , 45 points
How could I achive this?