title: How to sum two rows after count and union two tables
body: <p>I am trying to count over two tables and by union to take the results. How can i take the SUM of the rows afterwards?</p>
  
  <pre><code>select count(PARTNER_ID) from Administrator.PARTNERS
  union 
  select count(RECORD_ID) from Administrator.DELETED_RECORDS WHERE RECORD_BASE_TYPE = 'PARTNER'
  </code></pre>