敗家貓

select (case when qty_less6months < 0 and qty_6to12months < 0 then
                            (case when season_code in ('0', '1', '2', '3', '4') then 'value is negative'
                                  else 'No stock'
                             end)
             when qty_1to2years < 0 and qty_2to3years < 0 then
                            (case when season_code in ('A', 'B', 'C', 'D', 'E') then 'value is negative'
                                  else 'No stock'
                             end)
             else 'Stock Available'
        end) stock_check
from   jnc_lots_ageing_mexx_asof
where  rownum < 20
and    qty_less6months < 0 and qty_6to12months < 0