gistfile1.sql

select
  effective_date
, cur_period_rev.recognized_amount + past_period_rev.recognized_amount
from (
  select
    effective_date
  , recognized_amount 
  from recognized_revenue
  where recognized_date = date_format(curdate(), '%Y-%m-01')
  and effective_date >= date_format(curdate(), '%Y-%m-01')
) cur_period_rev
cross join (
  select
    sum(recognized_amount) recognized_amount
  from recognized_revenue
  where recognized_date = date_format(curdate(), '%Y-%m-01')
  and effective_date < date_format(curdate(), '%Y-%m-01')
  and effective_date = last_day(effective_date)
) past_period_rev
;