title: Increment "sequence" column based on alphabetical order of another column
body: <p>Assume the following schema:</p>
  
  <pre><code>text|sequence
  ----|--------
  Foo |       1
  Bar |       2
  Baz |       3
  </code></pre>
  
  <p>How would I <code>UPDATE</code> the <code>sequence</code> column so it incremented starting at 1 with no gaps based on the alphabetical order of the <code>text</code> column?</p>
  
  <p>The resulting data would look like:</p>
  
  <pre><code>text|sequence
  ----|--------
  Foo |       3
  Bar |       1
  Baz |       2
  </code></pre>