title: How to sort by timestamp difference in MySQL?
body: <p>suppose I have the following table:</p>
  
  <pre><code>name        birth(timestamp)          death(timestamp)
  --------   ----------------------   ---------------------
  person1      22-05-2013 21:59:00     22-05-2013 21:59:00
  person2      20-05-2013 21:58:58     27-06-2025 21:59:55
  </code></pre>
  
  <p>how can I sort this table in a way that it returns the longest-lived person first?</p>