title: Why cant the Count() operator be used in a where clause? how do i get around this?
body: <p>I'm trying to write a query to return the town, and the number of runners from each town where the number of runners is greater than 5.</p>
  
  <p>My Query right now look like this:</p>
  
  <blockquote>
    <p>select hometown, count(hometown) from marathon2016 where count(hometown) > 5 group by hometown order by count(hometown) desc;</p>
  </blockquote>
  
  <p>but sqlite3 responds with this:</p>
  
  <blockquote>
    <p>Error: misuse of aggregate: count()</p>
  </blockquote>
  
  <p>What am i doing wrong, Why cant I use the count() here, and what should I use instead.</p>