minor_league_pivot_query.sql

  SELECT t_plan.partner_id,
         plan_amount – for_amount variance
    FROM
   (SELECT partner_id, amount plan_amount
      FROM revplan_infos
     WHERE revplan_type = 'Plan') t_plan
    JOIN (
    SELECT partner_id, amount for_amount
      FROM revplan_infos
     WHERE revplan_type = 'Forecast') t_for
      ON t_for.partner_id = t_plan.partner_id