title: What order is used by First() function?
body: <p>Why do the following two queries return identical results?</p>
  
  <pre><code>SELECT FIRST(score) FROM (SELECT score FROM scores ORDER BY score ASC)
  SELECT FIRST(score) FROM (SELECT score FROM scores ORDER BY score DESC)
  </code></pre>
  
  <p>It's confusing, considering that I manually specify the order of subqueries.</p>