Before we had the OVER() clause for aggregates, this could only be achieved with a subquery or a join with a derived table.
I am realy lucky: I am having a hard time getting the wright answer from a query that is very complicated, trying to manipulate the data with group by, with, subqueries, etc. and maybe my answer to it would be the over(partition) case that, yesterday, I did not know the existence ...
I'll have to work on it more, but at least I understand better...
Thanks Hugo
Thanks da-zero
... and ya, thanks to UK and US for the good laughs:-D