title: Adding up subqueries with main query
body: <p>I would like to know how can I add up the result of my subqueries within a table. For example, I want to add up the following two queries in one statement.</p>
  
  <pre><code>SELECT SUM(A) - (SELECT SUM(B) FROM MyTable WHERE C&lt;A))
  FROM MyTable WHERE B&gt;C;
  
  SELECT SUM(B) - (SELECT SUM(C) FROM MyTable WHERE D&lt;F))
  FROM MyTable WHERE B=C;
  </code></pre>