title: How to do a case sensitive GROUP BY?
body: <p>If I execute the code below:</p>
  
  <pre><code>with temp as
  (
    select 'Test' as name
    UNION ALL
    select 'TEST'
    UNION ALL
    select 'test'
    UNION ALL
    select 'tester'
    UNION ALL
    select 'tester'
  )
  SELECT name, COUNT(name)
  FROM temp
  group by name
  </code></pre>
  
  <p>It returns the results:</p>
  
  <pre><code>TEST   3
  tester 2
  </code></pre>
  
  <p>Is there a way to have the group by be case sensitive so that the results would be:</p>
  
  <pre><code>Test   1
  TEST   1
  test   1
  tester 2
  </code></pre>