分类汇总

[kidslovely]

ID SCORE LEVE
SWSW_+DM10007402 55 2
SWSW_+DM10007402+SP10010203 26 3
SWSW_+DM10007402+SP10010203+SE10010208+SV14928811 5 5
SWSW_+DM10007402+SP10010203+SE10010208+SV14951041 6 5
SWSW_+DM10007402+SP10010203+SE10010208+SV14951042 2 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250951 1 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250952 3 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250953 3 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250954 3 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250955 2 5
SWSW_+DM10007402+SP10010203+SE10010208+SV80961755 1 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14928811 5 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14951041 6 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14951042 2 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250951 1 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250952 3 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250953 3 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250954 3 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250955 2 5
SWSW_+DM10007402+SP10010203+SE10010211+SV80961755 1 5
SWSW_+DM10007402+SP11381956 1 3
SWSW_+DM10007402+SP11381983 1 3
SWSW_+DM10007402+SP11381994 1 3
SWSW_+DM10007402+SP11381994+SV25951981 1 4

现在有个这样的需求，将3级的score未加5级score前的值加到5级和4级上，5级未加前的汇总数据加到3级明细的score上，4级未加前的汇总score加到3级上。3级未加4级汇总钱的score加到4级明细上。这个sql怎么写效率比较高呢？
达到下面的效果：
ID SCORE LEVE
SWSW_+DM10007402+SP10010203 78 3
SWSW_+DM10007402+SP10010203+SE10010208+SV14928811 31 5
SWSW_+DM10007402+SP10010203+SE10010208+SV14951041 32 5
SWSW_+DM10007402+SP10010203+SE10010208+SV14951042 28 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250951 27 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250952 29 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250953 29 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250954 29 5
SWSW_+DM10007402+SP10010203+SE10010208+SV18250955 28 5
SWSW_+DM10007402+SP10010203+SE10010208+SV80961755 27 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14928811 31 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14951041 32 5
SWSW_+DM10007402+SP10010203+SE10010211+SV14951042 28 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250951 27 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250952 29 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250953 29 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250954 29 5
SWSW_+DM10007402+SP10010203+SE10010211+SV18250955 28 5
SWSW_+DM10007402+SP10010203+SE10010211+SV80961755 27 5
SWSW_+DM10007402+SP11381994 2 3
SWSW_+DM10007402+SP11381994+SV25951981 2 4