select sum(decode(substr(promo_begin_date

Which query gives the correct output?