title: SQL Server 2008 R2 Grouping
body: <p>Here is the script I have.</p>
  
  <pre><code>select jt.exempt_status as ExemptStatus, COUNT(*) as ExemptCount
  from employee as e
  join job_title as jt
      on e.job_title = jt.job_title
  group by jt.exempt_status
  </code></pre>
  
  <p>When executed it displays</p>
  
  <pre><code>ExemptStatus     ExemptCount
  -----------------------------    
  E                2
  N                5
  </code></pre>
  
  <p>What I need it to display without changing the values in the jt.exempt_status field is.</p>
  
  <pre><code>ExemptStatus     ExemptCount
  -----------------------------    
  Exempt           2
  Non-Exempt       5
  </code></pre>