gistfile1.sql

select
  effective_date
, cur_period_rev.recognized_amount + past_period_rev.recognized_amount
from (
  select distinct effective_date fulldate from recognized_revenue
) pivot_date
join (
  select
    effective_date
  , recognized_amount 
  from recognized_revenue
) cur_period_rev on recognized_date = date_format(pivot_date.fulldate, '%Y-%m-01') and effective_date = pivot_date.fulldate
join (
  select
    recognized_date
  , sum(recognized_amount) recognized_amount
  from recognized_revenue
  where effective_date = last_day(effective_date)
  group by 1
) past_period_rev on recognized_date = date_format(pivot_date.fulldate, '%Y-%m-01')
;