Finding the highest quarter of the year I'm sitting here and do some practise but I just can't find the Solution. Maybe someone could give me some help?

I have a table and should find the highest sale amount of a quarter per year.

Data table:



My attempt:

SELECT Year, Quarter, MAX(SUM(Revenue)) OVER(PARTITION BY Year)
FROM Sale
GROUP BY Year, Quarter
ORDER BY Year, Quarter;


Output:



As you can see the numbers are correct.
But my expected output should be:

2012  |  4  |  25
2013  |  2  |  35


Would be great if someone has an idea.
Thanks in advance!


UPDATE:
Solution is found.
Forgot to mention. I used Oracle XE.

SELECT Year, Quarter, QMax
FROM (
  SELECT Year, Quarter,
    MAX(SUM(Revenue)) OVER(PARTITION BY Year) AS QMax,
    RANK() OVER (PARTITION BY Year ORDER BY SUM(Revenue) DESC) AS QRank
  FROM Sale
  GROUP BY Year, Quarter) QResult
WHERE QRank = 1
ORDER BY Year, Quarter;
Assuming the answer is 25 and 30, then this should work

SELECT Year, MAX(Quarter) Quarter, MAX(Revenue)
FROM Sale
GROUP BY Year
ORDER BY Year, Quarter