sum(decode(substr(promo_begin

Which query gives the correct output?