メモ：メモ一覧
更新

-- 条件1：前日比が8%以上 -- 条件2：前日の出来高100000以上 SELECT A.BRAND_CODE ,IFNULL(W.BRAND_NAME, 'NoName') AS BRAND_NAME ,A.END_AMT ,IFNULL(A.BEFORE_AMT,B.END_AMT) AS PRE_END_AMT ,B.START_AMT AS PRE_START_AMT ,B.HIGH_AMT AS PRE_HIGH_AMT ,B.VOLUME AS PRE_VOLUME 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 LEFT JOIN BrandMaster W ON W.BRAND_CODE = A.BRAND_CODE WHERE A.YMD = '20240508' AND A.END_AMT > IFNULL(A.BEFORE_AMT,B.END_AMT) * 1.08 AND A.END_AMT > 100 ORDER BY A.BRAND_CODE,A.YMD, A.VOLUME DESC