Oracle ORDER BY with rownum or have >= ALL

My database teacher asked me to write (on Oracle Server) a query: select the groupid with the highest score average for year 2010My database teacher asked me to write (on Oracl