SELECT
*
--DAMIN
--,MEMBER_CODE
--,ORDER_DATETIME
FROM
EC_ORDERS
LEFT JOIN
(SELECT MEMBER_CODE AS MINCODE,MIN(ORDER_DATETIME) AS DAMIN
FROM EC_ORDERS
WHERE ORDER_DATETIME LIKE '2023-07%'
GROUP BY MEMBER_CODE
ORDER BY ORDER_DATETIME)
ON MEMBER_CODE = MINCODE
WHERE EC_ORDERS.ORDER_DATETIME NOT LIKE '2023-07%'
GROUP BY MEMBER_CODE
HAVING cast(julianday(DAMIN) - julianday(MAX(ORDER_DATETIME)) as integer) >= 365
--AND NOT EXISTS (SELECT * FROM EC_ORDERS WHERE cast(julianday(DAMIN) - julianday(ORDER_DATETIME) as integer) < 365 AND )
--GROUP BY MEMBER_CODE
;