SELECT
    A.CODE,
    A.ORDER_DATE,
    A.OPTOUT
FROM
    (
    SELECT 
        MM.MEMBER_CODE CODE,
        MIN(EO.ORDER_DATETIME) ORDER_DATE,
        CASE MM.OPTOUT_TYPE
            WHEN 0 THEN "可"
            WHEN 1 THEN "不可"
            ELSE "不明"
        END OPTOUT
    FROM
        MEMBER_MST MM
    INNER JOIN
        EC_ORDERS EO ON MM.MEMBER_CODE = EO.MEMBER_CODE
    WHERE 1=1
        AND EO.ORDER_DATETIME >= "2023-07-01"
        AND EO.ORDER_DATETIME < "2023-08-01"
    GROUP BY
        MM.MEMBER_CODE
    ) A
    INNER JOIN 
    (
    SELECT 
        MM.MEMBER_CODE CODE,
        MAX(EO.ORDER_DATETIME) ORDER_DATE
    FROM
        MEMBER_MST MM
    INNER JOIN
        EC_ORDERS EO ON MM.MEMBER_CODE = EO.MEMBER_CODE
    WHERE
        EO.ORDER_DATETIME < "2023-07-01"
    GROUP BY
        MM.MEMBER_CODE
    ) B
    ON A.CODE = B.CODE
    -- )
 WHERE
     B.ORDER_DATE < date(A.ORDER_DATE, "-1 years") 
ORDER BY
    A.ORDER_DATE DESC,
    A.CODE DESC