INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12 , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–Úš°ÄÞ10 , JU.”Ä—p€–Úš°ÄÞ11 , JU.”Ä—p€–Úš°ÄÞ12
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.VALUE1) , SUM(JS.VALUE2) , SUM(JS.VALUE3) , SUM(JS.VALUE4) , SUM(JS.VALUE5) , SUM(JS.VALUE6) , SUM(JS.VALUE7) , SUM(JS.VALUE8) , SUM(JS.VALUE9) , SUM(JS.VALUE10) , SUM(JS.VALUE11) , SUM(JS.VALUE12) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iš°ÄÞ = SH.Ī•iš°ÄÞ AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iš°ÄÞ , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.VALUE1) , SUM(JU.VALUE2) , SUM(JU.VALUE3) , SUM(JU.VALUE4) , SUM(JU.VALUE5) , SUM(JU.VALUE6) , SUM(JU.VALUE7) , SUM(JU.VALUE8) , SUM(JU.VALUE9) , SUM(JU.VALUE10) , SUM(JU.VALUE11) , SUM(JU.VALUE12) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –Ú•W–ūŨĖ§ēŲU_MG SELECT YU.“ú•t , YU.Ī•iƒR[ƒh , YU.•i–Ú•Š—Þ‚P , YU.•i–Ú•Š—Þ‚Q , YU.“ūˆÓæƒR[ƒh , YU.“ūˆÓæ•Š—Þ , YU.ŋ‹æƒR[ƒh , YU.•”ƒR[ƒh , YU.•”‰ÛƒR[ƒh , YU.‰c‹Æ’S“–ŽŌƒR[ƒh , YU.”Ä—p€–ÚƒR[ƒh‚P‚O , YU.”Ä—p€–ÚƒR[ƒh‚P‚P , YU.”Ä—p€–ÚƒR[ƒh‚P‚Q , YU.‚u‚`‚k‚t‚d‚P , YU.‚u‚`‚k‚t‚d‚Q , YU.‚u‚`‚k‚t‚d‚R , YU.‚u‚`‚k‚t‚d‚S , YU.‚u‚`‚k‚t‚d‚T , YU.‚u‚`‚k‚t‚d‚U , YU.‚u‚`‚k‚t‚d‚V , YU.‚u‚`‚k‚t‚d‚W , YU.‚u‚`‚k‚t‚d‚X , YU.‚u‚`‚k‚t‚d‚P‚O , YU.‚u‚`‚k‚t‚d‚P‚P , YU.‚u‚`‚k‚t‚d‚P‚Q , YU.”NŒŽ“x , YU.”NT“x FROM –Ú•W–ūŨĖ§ēŲU_MH YU WHERE “ú•t BETWEEN 0 AND 0
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200739 AND 200751 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200808 AND 200810 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20080801 AND 20081021 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200739 AND 200751 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200808 AND 200810 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –Ú•W–ūŨĖ§ēŲU_MG SELECT YU.“ú•t , YU.Ī•iƒR[ƒh , YU.•i–Ú•Š—Þ‚P , YU.•i–Ú•Š—Þ‚Q , YU.“ūˆÓæƒR[ƒh , YU.“ūˆÓæ•Š—Þ , YU.ŋ‹æƒR[ƒh , YU.•”ƒR[ƒh , YU.•”‰ÛƒR[ƒh , YU.‰c‹Æ’S“–ŽŌƒR[ƒh , YU.”Ä—p€–ÚƒR[ƒh‚P‚O , YU.”Ä—p€–ÚƒR[ƒh‚P‚P , YU.”Ä—p€–ÚƒR[ƒh‚P‚Q , YU.‚u‚`‚k‚t‚d‚P , YU.‚u‚`‚k‚t‚d‚Q , YU.‚u‚`‚k‚t‚d‚R , YU.‚u‚`‚k‚t‚d‚S , YU.‚u‚`‚k‚t‚d‚T , YU.‚u‚`‚k‚t‚d‚U , YU.‚u‚`‚k‚t‚d‚V , YU.‚u‚`‚k‚t‚d‚W , YU.‚u‚`‚k‚t‚d‚X , YU.‚u‚`‚k‚t‚d‚P‚O , YU.‚u‚`‚k‚t‚d‚P‚P , YU.‚u‚`‚k‚t‚d‚P‚Q , YU.”NŒŽ“x , YU.”NT“x FROM –Ú•W–ūŨĖ§ēŲU_MH YU WHERE “ú•t BETWEEN 0 AND 0
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20100501 AND 20100711 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200926 AND 200937 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 201005 AND 201007 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20100501 AND 20100711 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200926 AND 200937 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 201005 AND 201007 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_DG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_DH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 20100501 AND 20100711 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_WG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_WH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 200926 AND 200937 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲU_MG SELECT JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q , SUM(JU.‚u‚`‚k‚t‚d‚P) , SUM(JU.‚u‚`‚k‚t‚d‚Q) , SUM(JU.‚u‚`‚k‚t‚d‚R) , SUM(JU.‚u‚`‚k‚t‚d‚S) , SUM(JU.‚u‚`‚k‚t‚d‚T) , SUM(JU.‚u‚`‚k‚t‚d‚U) , SUM(JU.‚u‚`‚k‚t‚d‚V) , SUM(JU.‚u‚`‚k‚t‚d‚W) , SUM(JU.‚u‚`‚k‚t‚d‚X) , SUM(JU.‚u‚`‚k‚t‚d‚P‚O) , SUM(JU.‚u‚`‚k‚t‚d‚P‚P) , SUM(JU.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JU.”NŒŽ“x) , MAX(JU.”NT“x) FROM –ūŨĖ§ēŲU_MH JU , Ī•iÏ―Ā SH , “ūˆÓæÏ―Ā TK WHERE “ú•t BETWEEN 201005 AND 201007 AND JU.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JU.“ūˆÓæƒR[ƒh = TK.“ūˆÓæƒR[ƒh GROUP BY JU.“ú•t , SH.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , TK.“ūˆÓæƒR[ƒh , TK.“ūˆÓæ•Š—Þ , TK.ŋ‹æƒR[ƒh , TK.•”ƒR[ƒh , TK.•”‰ÛƒR[ƒh , TK.‰c‹Æ’S“–ŽŌƒR[ƒh , JU.”Ä—p€–ÚƒR[ƒh‚P‚O , JU.”Ä—p€–ÚƒR[ƒh‚P‚P , JU.”Ä—p€–ÚƒR[ƒh‚P‚Q
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20100601 AND 20100711 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200931 AND 200937 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 201006 AND 201007 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20100601 AND 20100711 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200931 AND 200937 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 201006 AND 201007 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_DG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_DH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 20100601 AND 20100711 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_WG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_WH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 200931 AND 200937 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh
INSERT INTO –ūŨĖ§ēŲS_MG SELECT JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh , SUM(JS.‚u‚`‚k‚t‚d‚P) , SUM(JS.‚u‚`‚k‚t‚d‚Q) , SUM(JS.‚u‚`‚k‚t‚d‚R) , SUM(JS.‚u‚`‚k‚t‚d‚S) , SUM(JS.‚u‚`‚k‚t‚d‚T) , SUM(JS.‚u‚`‚k‚t‚d‚U) , SUM(JS.‚u‚`‚k‚t‚d‚V) , SUM(JS.‚u‚`‚k‚t‚d‚W) , SUM(JS.‚u‚`‚k‚t‚d‚X) , SUM(JS.‚u‚`‚k‚t‚d‚P‚O) , SUM(JS.‚u‚`‚k‚t‚d‚P‚P) , SUM(JS.‚u‚`‚k‚t‚d‚P‚Q) , MAX(JS.”NŒŽ“x) , MAX(JS.”NT“x) FROM –ūŨĖ§ēŲS_MH JS , H’öŽč‡Ï―Ā KO , Ī•iÏ―Ā SH , Žd“üæÏ―Ā SR WHERE “ú•t BETWEEN 201006 AND 201007 AND JS.•i–žQHęQ‡˜ = KO.•i–žQHęQ‡˜ AND JS.Ī•iƒR[ƒh = SH.Ī•iƒR[ƒh AND JS.Žd“üæƒR[ƒh = SR.Žd“üæƒR[ƒh GROUP BY JS.“ú•t , KO.Ī•iƒR[ƒh , SH.•i–Ú•Š—Þ‚P , SH.•i–Ú•Š—Þ‚Q , SR.Žd“üæƒR[ƒh , SR.Žd“üæ•Š—Þ , SR.Žx•ĨæƒR[ƒh , KO.•”ƒR[ƒh , KO.•”‰ÛƒR[ƒh , KO.Žč”z’S“–ŽŌƒR[ƒh , KO.•i–žQHęQ‡˜ , KO.‰Č–ÚƒR[ƒh , KO.‰Č–ڕ⏕ƒR[ƒh