title: Is it possible to use alias in ORDER BY?
body: <p>I have a query</p>
  
  <pre><code>SELECT username, count(username) as number
  FROM table
  GROUP BY username;
  </code></pre>
  
  <p>and I want to add</p>
  
  <pre><code>ORDER BY number DESC
  </code></pre>
  
  <p>to it, but it doesn't work in Access and it thinks that "number" is a parameter.
  I know that I can use</p>
  
  <pre><code>ORDER BY count(username) DESC
  </code></pre>
  
  <p>or</p>
  
  <pre><code>ORDER BY 2 DESC
  </code></pre>
  
  <p>but is it possible to use column alias in <code>ORDER BY</code> in MS Access?</p>