title: Group by Range ms access database
body: <p>I'd like to generate a table of counts, that shows how many times scores appeared in each range im ms access database.</p>
  
  <p>database table </p>
  
  <pre><code>smsId int, Age text,etc.. 
  
  Age   range  | number of occurrences
  -------------------------------------
     0-9       |        11
    10-19      |        14
    20-29      |         3
     ...       |       ...
  </code></pre>
  
  <p>What is sql syntax</p>