[oracle] 전체 최대 최소 값 조회

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