SELECT E.ORDER_DATETIME AS ORDER_DATE
        , M.MEMBER_CODE AS CODE
        , CASE WHEN M.OPTOUT_TYPE = 0 THEN '可'
                WHEN M.OPTOUT_TYPE = 1 THEN '不可'
                ELSE '不明' END AS OPTOUT
FROM EC_ORDERS AS E
INNER JOIN MEMBER_MST AS M
ON E.MEMBER_CODE = M.MEMBER_CODE
WHERE E.ORDER_DATETIME BETWEEN '2023-07-01 00:00:00' AND '2023-07-31 23:59:59'
AND EXISTS (SELECT E2.ORDER_DATETIME FROM EC_ORDERS AS E2 WHERE E2.ORDER_DATETIME < DATETIME(E.ORDER_DATETIME, '-1 YEAR') AND E.MEMBER_CODE = E2.MEMBER_CODE)
GROUP BY M.MEMBER_CODE
ORDER BY E.ORDER_DATETIME DESC, M.MEMBER_CODE DESC;