title: Selecting top 10 counts in SQLite
body: <p>I have a table which records questions, their answers, and their authors. The column names are as follows:</p>
  
  <p>id, question, answers, author</p>
  
  <p>I would like to get a list of top 10 authors who have written the most questions. So it would need to first count the number of questions each author has written then sort them by the count then return the top 10.</p>
  
  <p>This is in SQLite and I'm not exactly sure how to get the list of counts. The second part should be fairly simple as it's just an <code>ORDER BY</code> and a <code>LIMIT 10</code>. How can I get the counts into a list which I can select from?</p>