title: Using BETWEEN clause in Plotalot
body: <p>Trying to create league tables and display using Plotalot graphs. I'm using the BETWEEN clause but I don't seem to get the result I expect, which is ...no results! Would be grateful for support with this.</p>
  
  <p>Code is</p>
  
  <pre><code>SELECT FieldName, COUNT(FieldValue) AS "Total" 
  FROM jos_rsform_submission_values 
  WHERE FieldName LIKE'Goals' AND "Total" BETWEEN 1 AND 20 ORDER BY Total DESC
  </code></pre>