title: combine two group by queries to one to get count of both table's record in sql server
body: <p>I have two queries to get Tutor and Parent Counts by Locations, are below:</p>
  
  <pre><code>Select a.LocationId, COUNT(*)  from TutorAddress ta 
  inner join Address a on a.Id=ta.AddressId group by a.LocationId
  </code></pre>
  
  <p>Out Put is: </p>
  
  <pre><code>LocationId  Count
  1            4
  14           13
  </code></pre>
  
  <p>second query is:</p>
  
  <pre><code>Select a.LocationId, COUNT(*)  from ParentAddress pa 
  inner join Address a on a.Id=pa.AddressId group by a.LocationId
  </code></pre>
  
  <p>Out Put is: </p>
  
  <pre><code>LocationId  Count
  1            6
  14           3
  12           8
  </code></pre>
  
  <p>I want to merge these two queries and get the result single output as below:</p>
  
  <pre><code>LocationId  tutorCount  ParentCount
  1              4           6
  14            13           3
  12            0            8
  </code></pre>
  
  <p>is it possible, i m not able to get how i can achieve this. please help. </p>