title: Subtraction of counts of 2 tables
body: <p>I have 2 different tables, A and B. A is something like <code>created</code> and b is <code>removed</code> </p>
  
  <p>I want to obtain the nett difference of the counts per week in an SQL query.</p>
  
  <p>Currently I have</p>
  
  <pre><code>SELECT DATE_TRUNC('week', TIMESTAMP AT time ZONE '+08') AS Week,
         Count(id) AS "A - New"
  FROM table_name.A
  GROUP BY 1
  ORDER BY 1
  </code></pre>
  
  <p>This gets me the <code>count per week</code> for table A only. How could I incorporate the logic of subtracting the same <code>Count(id)</code> from B, for the same timeframe?</p>
  
  <p>Thanks! :)</p>