title: count how many times in an sqlite3 database table column the values occurs
body: <p>I have been performing a query to count how many times in my sqlite3 database table (Users), within the column "country", the value "Australia" occurs.</p>
  
  <pre><code>australia = db.session.query(Users.country).filter_by(country="Australia").count()
  </code></pre>
  
  <p>I need to do this in a more dynamic way for any country value that may be within this column.</p>
  
  <p>I have tried the following but unfortunately I only get a count of 0 for all values that are passed in the loop variable (each).</p>
  
  <pre><code>country = list(db.session.query(Users.country))
  
  country_dict = list(set(country))
  
  for each in country_dict:
  
      print(db.session.query(Users.country).filter_by(country=(str(each))).count())
  </code></pre>
  
  <p>Any assistance would be greatly appreciated.</p>