title: Combine few queries
body: <p>I have written 4 queries , 
  all of the are showing the details of one column which is [Source]</p>
  
  <p>I need to combine this queries together so the result will be Shawn in one table with all the results per each [Source] (like 1 table with all the results, without duplicate parameters)</p>
  
  <p>Thanks a lot . 
   The Queries : </p>
  
  <p>1)</p>
  
  <pre><code>SELECT  [Source] ,
          COUNT (DISTINCT ROW_ID ) AS 'Number Of Contacts'
  FROM [SRL-TST].[dbo].[TBL_SRL_Contacts]
  GROUP BY [Source]
  </code></pre>
  
  <p>2)</p>
  
  <pre><code>SELECT [Source] , 
         COUNT (DISTINCT ROW_ID ) AS 'FULL'
  FROM dbo.TBL_SRL_Contacts
  WHERE Email IS NOT NULL 
  AND Company IS NOT NULL
  AND Privetphone IS NOT NULL
  AND Secondphone IS NOT NULL
  GROUP BY [Source]
  </code></pre>
  
  <p>3)</p>
  
  <pre><code>SELECT [Source] , 
         COUNT (DISTINCT ROW_ID ) AS 'PARTLY'
  FROM dbo.TBL_SRL_Contacts
  WHERE Email IS NOT NULL 
  OR Company IS NOT NULL
  OR Privetphone IS NOT NULL
  OR Secondphone IS NOT NULL
  </code></pre>
  
  <p>GROUP BY [Source]</p>
  
  <p>4)</p>
  
  <pre><code>SELECT [Source] , 
         COUNT(DISTINCT ROW_ID ) AS 'MISSING'
  FROM dbo.TBL_SRL_Contacts
  WHERE Email IS  NULL 
  AND Company IS  NULL
  AND Privetphone IS  NULL
  AND Secondphone IS  NULL
  GROUP BY [Source]
  </code></pre>