メモリストページ

メモ：メモ一覧

-- セリクラ
SELECT A.*
FROM EveryDay4Data A
INNER JOIN EveryDay4Data B ON
	B.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = A.YMD)
AND B.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay4Data C ON
	C.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = B.YMD)
AND C.BRAND_CODE = A.BRAND_CODE

WHERE 
	A.YMD BETWEEN '20190101' AND '20190301'
AND A.END_AMT > 200
AND A.END_AMT < A.START_AMT
AND B.END_AMT < B.START_AMT
AND C.END_AMT < C.START_AMT

AND (A.START_AMT - A.END_AMT) > B.START_AMT - B.END_AMT
AND (B.START_AMT - B.END_AMT) > C.START_AMT - C.END_AMT

AND A.END_AMT < B.END_AMT
AND B.END_AMT < C.END_AMT
AND C.END_AMT < C.move5
AND A.VOLUME > C.VOLUME * 2
AND A.VOLUME > 100000000 / A.END_AMT

-- 上昇（未完成）

SELECT A.*
FROM EveryDay4Data A
INNER JOIN EveryDay4Data B ON
	B.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = A.YMD)
AND B.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay4Data C ON
	C.YMD = (select Z.BEF_YMD from EigyoCalendar Z where Z.YMD = B.YMD)
AND C.BRAND_CODE = A.BRAND_CODE

WHERE 
	A.YMD BETWEEN '20210401' AND '20210501'
AND A.END_AMT > 200
AND A.END_AMT > A.START_AMT
AND B.END_AMT > B.START_AMT
AND C.END_AMT > C.START_AMT

AND A.END_AMT > B.END_AMT
AND B.END_AMT > C.END_AMT
AND C.END_AMT > C.move5

AND C.move5 < C.move75 * 1.08