title: SQL show two columns of data from different tables side by side without join
body: <p>I have two tables which both have column called identity_type, which takes on one of 10 values. </p>
  
  <p>Identity_type has the same values in both tables. </p>
  
  <p>I want to be able to show the count of each identity_type for each table side by side, without trying to join the data. Is this possible?</p>
  
  <p>I.e., what I'm trying to show is the output of: </p>
  
  <pre><code>SELECT * FROM table GROUP BY identity_type
  </code></pre>
  
  <p>for table_1 and table_2 side by side. </p>