select the_date as "date", 
round(months_between(first_date,second_date),0) months_old
,product,extract(year from the_date) year
,case 
  when a=b then 'c' 
  else 'd'
  end tough_one
from ...
where...