SELECT
    coalesce(sale_end_date,'2024-07-31')
FROM
    goods
WHERE
    valid_flg = '0'
    AND sale_end_date IS NULL;