title: hive error, getting an EOF error in subtract query
body: <p>I am getting an, missing EOF at '-' near HAB, the query for the most part looks correct. just not sure how to implement minus in HIVE.</p>
  
  <pre><code>SELECT
      a.playerID AS ID,
      a.yearID AS yearID,
      (b.HAB - a.EG) AS HAB-EG
  FROM 
      (SELECT
          playerID,
          yearID,
          (E/G) AS EG
      FROM fielding
      WHERE (
              yearID &gt; 2005
              AND yearID &lt; 2009
              AND G &gt; 20 
              )
      ) AS a
  JOIN
      (SELECT
          id,
          year,
          (hits/ab) AS HAB
      FROM batting
      WHERE( 
              year &gt; 2005
              AND year &lt; 2009 
              AND ab &gt; 40 
              )
      ) AS b ON a.playerID = b.id AND a.yearID = b.year;
  </code></pre>