title: count and order in sql at ms-access
body: <p>I have a table (called Tweets) in ms-access that looks like this</p>
  
  <pre><code>text    screenName
  lala      user1
  la        user2
  lal       user3
  lalala    user1
  l         user1
  a         user4
  </code></pre>
  
  <p>I would like to have in the end a table, that will contain the number of <code>text</code> per user. The column with the number of <code>text</code>, I would like to have a certain name for it (e.g. <code>newColumn</code>) and also the table to be sorted first by the number of texts (<code>newColumn</code>) (descending) and then by the <code>screenName</code> (ascending).</p>
  
  <p>So far I have </p>
  
  <pre><code>SELECT COUNT(text), screenName
  FROM Tweets
  GROUP BY screenName;
  </code></pre>
  
  <p>But I don't know how to sort and to rename the new column.</p>