SELECT ORDER_DATETIME AS ORDER_DATE, EC_ORDERS.MEMBER_CODE AS CODE, OPTOUT_TYPE AS OPTOUT
FROM EC_ORDERS INNER JOIN MEMBER_MST ON EC_ORDERS.MEMBER_CODE = MEMBER_MST.MEMBER_CODE
WHERE ORDER_DATETIME BETWEEN '2023-07-01' AND '2023-07-31'
ORDER BY ORDER_DATETIME DESC;