title: Complex MySQL rank query with ties
body: <p>Let's say I had the following table:</p>
  
  <pre><code>id | name | points  
  -------------------
  1  | joe  | 100  
  2  | bob  | 95  
  3  | max  | 95  
  4  | leo  | 90
  </code></pre>
  
  <p>Can I produce a reversed rank recordset like so:</p>
  
  <pre><code>id | name | points | rank  
  --------------------------
  4  | leo  | 90     | 1  
  3  | max  | 95     | 2.5  
  2  | bob  | 95     | 2.5   
  1  | joe  | 100    | 4  
  </code></pre>