SELECT DRG,
COUNT( 1 ) CASE_CNT,
AVG( FEE ),
DEDIAN (FEE ),
PERCENTILE_DISC(0.25) WITHIN GROUP(ORDER BY FEE ASC) P25, -- Q1
PERCENTILE_DISC(0.5) WITHIN GROUP( ORDER BY FEE ASC) P50, -- Q2
PERCENTILE_DISC(0.75) WITHIN GROUP( ORDER BY FEE ASC) P75 -- Q3
FROM MEDICAL_RECORD
WHERE YEAR_TIME = 2012
GROUP BY DRG