title: SQL: How to count occurrences based on file extension
body: <p>I have a query which returns a column of values:</p>
  
  <pre><code>?????? ?? ?????? ??????? ?.?..xlsx
  1028-13055 Single Patient Focus Wave 3.sav
  2.xlsx
  2011 BBQ (13Dec2013).sav
  2014 Health IT Purchasing Intentions Survey Results.xlsx
  2014 Safety Training and Safety Professionals Survey.sav
  </code></pre>
  
  <p>How do I count the number of occurrences based on the file extensions? In the above example, we have three rows for the xlsx extension and two for the sav extension?</p>