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