SELECT SUM(TOT_SCORE) TOT_SCORE , MIN(TOT_SCORE) MIN_SCORE , MIN(COMI_ID) KEEP(DENSE_RANK FIRST ORDER BY TOT_SCORE DESC) MIN_COMI_ID , MAX(TOT_SCORE) MAX_SCORE , MAX(COMI_ID) KEEP(DENSE_RANK LAST ORDER BY TOT_SCORE DESC) MAX_COMI_ID FROM EXAMPLE GROUP BY GROUP_ID