UPDATE
    GOODS
SET
	SALE_END_DATE = '2024-07-31'
FROM
	GOODS AS TARG
WHERE
	TARG.VALID_FLG = '0'
	AND TARG.SALE_END_DATE IS NULL
;