[selectRecords]
select 
	 kbn
	,cd
	,han
	,coalesce(uri01,0) as uri01
	,coalesce(arari01,0) as arari01
	,coalesce(arari01_ritu,0) as arari01_ritu
	,coalesce(uri02,0) as uri02
	,coalesce(arari02,0) as arari02
	,coalesce(arari02_ritu,0) as arari02_ritu
	,coalesce(uri03,0) as uri03
	,coalesce(arari03,0) as arari03
	,coalesce(arari03_ritu,0) as arari03_ritu
	,coalesce(uri04,0) as uri04
	,coalesce(arari04,0) as arari04
	,coalesce(arari04_ritu,0) as arari04_ritu
	,coalesce(uri05,0) as uri05
	,coalesce(arari05,0) as arari05
	,coalesce(arari05_ritu,0) as arari05_ritu
	,coalesce(uri06,0) as uri06
	,coalesce(arari06,0) as arari06
	,coalesce(arari06_ritu,0) as arari06_ritu
	,coalesce(uri07,0) as uri07
	,coalesce(arari07,0) as arari07
	,coalesce(arari07_ritu,0) as arari07_ritu
--	,coalesce(uri07,0) as uri07
--	,coalesce(arari07,0) as arari07
--	,coalesce(arari07_ritu,0) as arari07_ritu
	,coalesce(uri08,0) as uri08
	,coalesce(arari08,0) as arari08
	,coalesce(arari08_ritu,0) as arari08_ritu
	,coalesce(uri09,0) as uri09
	,coalesce(arari09,0) as arari09
	,coalesce(arari09_ritu,0) as arari09_ritu
	,coalesce(uri10,0) as uri10
	,coalesce(arari10,0) as arari10
	,coalesce(arari10_ritu,0) as arari10_ritu
	,coalesce(uri11,0) as uri11
	,coalesce(arari11,0) as arari11
	,coalesce(arari11_ritu,0) as arari11_ritu
	,coalesce(uri12,0) as uri12
	,coalesce(arari12,0) as arari12
	,coalesce(arari12_ritu,0) as arari12_ritu
	,coalesce(uri01_ly,0) as uri01_ly
	,coalesce(arari01_ly,0) as arari01_ly
	,coalesce(arari01_ly_ritu,0) as arari01_ly_ritu
	,coalesce(uri02_ly,0) as uri02_ly
	,coalesce(arari02_ly,0) as arari02_ly
	,coalesce(arari02_ly_ritu,0) as arari02_ly_ritu
	,coalesce(uri03_ly,0) as uri03_ly
	,coalesce(arari03_ly,0) as arari03_ly
	,coalesce(arari03_ly_ritu,0) as arari03_ly_ritu
	,coalesce(uri04_ly,0) as uri04_ly
	,coalesce(arari04_ly,0) as arari04_ly
	,coalesce(arari04_ly_ritu,0) as arari04_ly_ritu
	,coalesce(uri05_ly,0) as uri05_ly
	,coalesce(arari05_ly,0) as arari05_ly
	,coalesce(arari05_ly_ritu,0) as arari05_ly_ritu
	,coalesce(uri06_ly,0) as uri06_ly
	,coalesce(arari06_ly,0) as arari06_ly
	,coalesce(arari06_ly_ritu,0) as arari06_ly_ritu
	,coalesce(uri07_ly,0) as uri07_ly
	,coalesce(arari07_ly,0) as arari07_ly
	,coalesce(arari07_ly_ritu,0) as arari07_ly_ritu
--	,coalesce(uri07_ly,0) as uri07_ly
--	,coalesce(arari07_ly,0) as arari07_ly
--	,coalesce(arari07_ly_ritu,0) as arari07_ly_ritu
	,coalesce(uri08_ly,0) as uri08_ly
	,coalesce(arari08_ly,0) as arari08_ly
	,coalesce(arari08_ly_ritu,0) as arari08_ly_ritu
	,coalesce(uri09_ly,0) as uri09_ly
	,coalesce(arari09_ly,0) as arari09_ly
	,coalesce(arari09_ly_ritu,0) as arari09_ly_ritu
	,coalesce(uri10_ly,0) as uri10_ly
	,coalesce(arari10_ly,0) as arari10_ly
	,coalesce(arari10_ly_ritu,0) as arari10_ly_ritu
	,coalesce(uri11_ly,0) as uri11_ly
	,coalesce(arari11_ly,0) as arari11_ly
	,coalesce(arari11_ly_ritu,0) as arari11_ly_ritu
	,coalesce(uri12_ly,0) as uri12_ly
	,coalesce(arari12_ly,0) as arari12_ly
	,coalesce(arari12_ly_ritu,0) as arari12_ly_ritu
	,coalesce(uri01_2ya,0) as uri01_2ya
	,coalesce(arari01_2ya,0) as arari01_2ya
	,coalesce(arari01_2ya_ritu,0) as arari01_2ya_ritu
	,coalesce(uri02_2ya,0) as uri02_2ya
	,coalesce(arari02_2ya,0) as arari02_2ya
	,coalesce(arari02_2ya_ritu,0) as arari02_2ya_ritu
	,coalesce(uri03_2ya,0) as uri03_2ya
	,coalesce(arari03_2ya,0) as arari03_2ya
	,coalesce(arari03_2ya_ritu,0) as arari03_2ya_ritu
	,coalesce(uri04_2ya,0) as uri04_2ya
	,coalesce(arari04_2ya,0) as arari04_2ya
	,coalesce(arari04_2ya_ritu,0) as arari04_2ya_ritu
	,coalesce(uri05_2ya,0) as uri05_2ya
	,coalesce(arari05_2ya,0) as arari05_2ya
	,coalesce(arari05_2ya_ritu,0) as arari05_2ya_ritu
	,coalesce(uri06_2ya,0) as uri06_2ya
	,coalesce(arari06_2ya,0) as arari06_2ya
	,coalesce(arari06_2ya_ritu,0) as arari06_2ya_ritu
	,coalesce(uri07_2ya,0) as uri07_2ya
	,coalesce(arari07_2ya,0) as arari07_2ya
	,coalesce(arari07_2ya_ritu,0) as arari07_2ya_ritu
--	,coalesce(uri07_2ya,0) as uri07_2ya
--	,coalesce(arari07_2ya,0) as arari07_2ya
--	,coalesce(arari07_2ya_ritu,0) as arari07_2ya_ritu
	,coalesce(uri08_2ya,0) as uri08_2ya
	,coalesce(arari08_2ya,0) as arari08_2ya
	,coalesce(arari08_2ya_ritu,0) as arari08_2ya_ritu
	,coalesce(uri09_2ya,0) as uri09_2ya
	,coalesce(arari09_2ya,0) as arari09_2ya
	,coalesce(arari09_2ya_ritu,0) as arari09_2ya_ritu
	,coalesce(uri10_2ya,0) as uri10_2ya
	,coalesce(arari10_2ya,0) as arari10_2ya
	,coalesce(arari10_2ya_ritu,0) as arari10_2ya_ritu
	,coalesce(uri11_2ya,0) as uri11_2ya
	,coalesce(arari11_2ya,0) as arari11_2ya
	,coalesce(arari11_2ya_ritu,0) as arari11_2ya_ritu
	,coalesce(uri12_2ya,0) as uri12_2ya
	,coalesce(arari12_2ya,0) as arari12_2ya
	,coalesce(arari12_2ya_ritu,0) as arari12_2ya_ritu
from(
	select
		1 as kbn
		,coalesce(mtk.cat_cd,'') as cd
		--,coalesce(hn.han_name,'')||'('||coalesce(mtk.cat_cd,'')||')' as han
		,(case when coalesce(mtk.cat_cd,'')= '' then '' else coalesce(hn.han_name,'')||'('||coalesce(mtk.cat_cd,'')||')' end) as han
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ),0) * 100)
		as arari01_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_2ya_ritu
	from t_uri tu
	left join m_tokui mtk on (mtk.tok_cd = tu.tok_cd)
	left join m_hanyo hn on (hn.mst_kbn = '35' and hn.han_cd = mtk.cat_cd)
	left join m_tanto tn on (tn.tan_cd = tu.tan_cd)
	where 1 = 1
	and jucyu_flg = 0
	and tu.del_flg = 0
	and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mtk.cat_cd = '&4'))
	and (('' = '&24') or (tu.tan_cd >= '&24')) and (('' = '&25') or (tu.tan_cd <= '&25'))
	and (('' = '&20') or (mtk.tok_cd >= '&20')) and (('' = '&21') or (mtk.tok_cd <= '&21'))
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう --------- Start
	and tu.syori_ymd >= TO_CHAR(TO_DATE('&18'||'&19'||'01', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD')
	and tu.syori_ymd < (TO_CHAR(&18 + 1,'FM9999')||'&19'||'00')
--	and tu.syori_ymd between TO_CHAR(TO_DATE('&18'||'0101', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD') and ('&18'||'1231')
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう ---------   End
	group by  mtk.cat_cd,hn.han_name
	union all select/*
		2 as kbn
		,coalesce(mtk.cat_cd,'') as cd
		--,coalesce(hn.han_name,'')||'('||coalesce(mtk.cat_cd,'')||')' as han
		,(case when coalesce(mtk.cat_cd,'') = '' then '' else coalesce(hn.han_name,'')||'('||coalesce(mtk.cat_cd,'')||')' end) as han
		,'' as tok_cd
		,'得意先分類合計' as tok_rnm
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ),0) * 100)
		as arari01_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_2ya_ritu
	from t_uri tu
	left join m_tokui mtk on (mtk.tok_cd = tu.tok_cd)
	left join m_hanyo hn on (hn.mst_kbn = '35' and hn.han_cd = mtk.cat_cd)
	left join m_tanto tn on (tn.tan_cd = tu.tan_cd)
	where 1 = 1
	and jucyu_flg = 0
	and tu.del_flg = 0
	and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mtk.cat_cd = '&4'))
	and (('' = '&24') or (tu.tan_cd >= '&24')) and (('' = '&25') or (tu.tan_cd <= '&25'))
	and (('' = '&20') or (mtk.tok_cd >= '&20')) and (('' = '&21') or (mtk.tok_cd <= '&21'))
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう --------- Start
	and tu.syori_ymd >= TO_CHAR(TO_DATE('&18'||'&19'||'01', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD')
	and tu.syori_ymd < (TO_CHAR(&18 + 1,'FM9999')||'&19'||'00')
--	and tu.syori_ymd between TO_CHAR(TO_DATE('&18'||'0101', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD') and ('&18'||'1231')
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう ---------   End
	group by  coalesce(mtk.cat_cd,''),hn.han_name
	union all select*/
		3 as kbn
		,null as cd
		,'総合計' as han
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM'), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ),0) * 100)
		as arari01_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 months' AS INTERVAL),'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_ly
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_ly
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('1 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_ly_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri01_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari01_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari01_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri02_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari02_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('1 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari02_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri03_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari03_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('2 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari03_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri04_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari04_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('3 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari04_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri05_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari05_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('4 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari05_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri06_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari06_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('5 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari06_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri07_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari07_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('6 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari07_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri08_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari08_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('7 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari08_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri09_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari09_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('8 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari09_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri10_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari10_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('9 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari10_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri11_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari11_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('10 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari11_2ya_ritu
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end)
		as uri12_2ya
		, sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)
		as arari12_2ya
		, ((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) - sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.genka_gaku)else(null)end)) / nullif((sum(case(substr(tu.syori_ymd,1,6))when TO_CHAR(TO_DATE('&18'||'&19', 'YYYYMM') + CAST('11 month' AS INTERVAL) - CAST('2 year' AS INTERVAL), 'YYYYMM')then(tu.zeinuki_gaku)else(null)end) ) ,0) * 100)
		as arari12_2ya_ritu
	from t_uri tu
	left join m_tokui mtk on (mtk.tok_cd = tu.tok_cd)
	left join m_hanyo hn on (hn.mst_kbn = '35' and hn.han_cd = mtk.cat_cd)
	left join m_tanto tn on (tn.tan_cd = tu.tan_cd)
	where 1 = 1
	and jucyu_flg = 0
	and tu.del_flg = 0
	and (('' = '&2') or (tn.bu_cd = '&2'))
	and (('' = '&4') or (mtk.cat_cd = '&4'))
	and (('' = '&24') or (tu.tan_cd >= '&24')) and (('' = '&25') or (tu.tan_cd <= '&25'))
	and (('' = '&20') or (mtk.tok_cd >= '&20')) and (('' = '&21') or (mtk.tok_cd <= '&21'))
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう --------- Start
	and tu.syori_ymd >= TO_CHAR(TO_DATE('&18'||'&19'||'01', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD')
	and tu.syori_ymd < (TO_CHAR(&18 + 1,'FM9999')||'&19'||'00')
--	and tu.syori_ymd between TO_CHAR(TO_DATE('&18'||'0101', 'YYYYMMDD') - CAST('2 year' AS INTERVAL), 'YYYYMMDD') and ('&18'||'1231')
-- 2018.09.28 KSP K.Takahahsi 全体の範囲指定が1月始まり以外はずれてしまう ---------   End
) s1
order by s1.cd,s1.kbn;