title: SQL Server Select Statement Columns
body: <p>Original Query:</p>
  
  <pre><code>select StudyID, count(CompletedDate), count(Removed), count(RemovalReason)
  from Study a
  full outer join Households b
  on a.HouseholdID = b.HouseholdID
  where StudyID = '123456'
  and Removed = 1
  and RemovalReason = 5
  group by StudyID
  </code></pre>
  
  <p>How do I write out this query so that for each column (CompletedDate, Removed, and RemovalReason) is not restricted to the conditions (i.e. Removed = 1, Removal Reason = 5) and only applies to the specific column. If I execute this query, it will not show me the total count for CompletedDate because I'm restricting it to these conditions. Is there a way to write it directly next to count?</p>
  
  <p>Table/Columns - Study:
  HouseholdID (primary key),
  StudyID,
  CompletedDate</p>
  
  <p>Table/Columns - Households:
  HouseholdID (primary key),
  Removed,
  RemovalReason</p>