title: sql query count multiple rows between two dates
body: <p>Greetings,
  I am trying to build a query that will provide me with the totals of all records (some records are recurring) between two dates. I am stuck at the following query:</p>
  
  <pre><code>SELECT DISTINCT Country, COUNT(Country) as Count, Date 
  From DataSet 
  GROUP BY Country, Date 
  ORDER BY Country HAVING Date&gt;'1/1/2000'
  </code></pre>
  
  <p>Thanks in advance.</p>