title: Case insensitive duplicates SQL
body: <p>So I have a users table where the user.username has many duplicates like:</p>
  
  <p><code>username</code> and <code>Username</code> and <code>useRnAme</code><br>
  <code>john</code> and <code>John</code> and <code>jOhn</code></p>
  
  <p>That was a bug and these three records should have been only one.</p>
  
  <p>I'm trying to come up with a SQL query that lists all of these cases ordered by their creation date, so ideally the result should be something like this:</p>
  
  <pre><code>username jan01
  useRnAme jan02
  Username jan03
  john     feb01 
  John     feb02
  jOhn     feb03
  </code></pre>
  
  <p>Any suggestions will be much appreciated</p>