SELECT
    e.ORDER_DATETIME AS ORDER_DATE
    ,e.MEMBER_CODE AS CODE
    ,CASE WHEN m.OPTOUT_TYPE=0 THEN '可'
          WHEN m.OPTOUT_TYPE=1 THEN '不可'
          else '不明'
     END AS OPTOUT
FROM 
    EC_ORDERS e INNER JOIN MEMBER_MST m
    ON e.MEMBER_CODE = m.MEMBER_CODE
WHERE
    date(ORDER_DATETIME) BETWEEN '2023-07-01' AND '2023-07-31'
ORDER BY
    e.ORDER_DATETIME DESC
    ,e.MEMBER_CODE DESC