select
    *,
    coalesce(sale_end_date,'2024-07-31') as sale_end_date
from
    goods
where
    valid_flg=0
    and sale_end_date is null;