1到100想加之和oracle,请教:关于1+2+3+4+..+100

SELECT month,

area_code,

round(SUM(commision_fee), 2),

round(SUM(decode(fee_name, '1', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '2', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '3', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '4', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '5', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '6', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '7', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '8', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '9', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '10', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '11', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '12', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '13', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '14', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '15', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '16', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '17', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '18', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '19', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '20', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '21', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '22', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '23', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '24', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '25', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '26', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '27', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '28', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '29', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '30', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '31', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '32', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '33', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '34', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '35', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '36', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '37', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '38', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '39', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '40', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '41', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '42', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '43', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '44', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '45', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '46', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '47', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '48', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '49', commision_fee, 0)), 2),

round(SUM(decode(fee_name, '50', commision_fee, 0)), 2)

FROM tab1

GROUP BY month,

area_code

如何构造以上语句