My engish beeing what it is, I did also not get the differance between the first two answers, but that's ok. I learned something new and it is the important thing. Thank you!

I am not sure of what "over" does thought...and yes, I was starting to thing that it does the same thing than a group by.

So, what would be the first purpose of using an Over(partition by) function?