メモ：メモ一覧
更新

SELECT A.YMD ,A.BRAND_CODE ,A.END_AMT ,B.START_AMT AS AFT_START ,B.END_AMT AS AFT_END ,B.LOW_AMT AS AFT_LOW ,B.HIGH_AMT AS AFT_HIGH ,A.TIME_NUM FROM EveryDay4Data A LEFT JOIN EveryDay4Data B ON B.BRAND_CODE = A.BRAND_CODE AND B.TIME_NUM = A.TIME_NUM + 1 WHERE A.YMD = 【YMD】 AND A.BEFORE_AMT > 0 AND A.END_AMT > 400 ORDER BY (A.END_AMT - A.BEFORE_AMT) / A.END_AMT DESC LIMIT 10