title: SQL - Counting data types and printing highest occurrence first
body: <p>I am required to produce a list of the different types of pets with a count of how many there are of each ignoring when there is only one type of pet. This should also be listed in descending order. The columns available in my pet table are as follows pet_id, Name, Type, Breed, Gender, Born, owner_id and Notes. But only the Type will be utilised as far as I know.</p>
  
  <p>Below is what I have attempted thus far but it clearly needs improvement and please note this will be executed within Microsoft Access.</p>
  
  <pre><code>SELECT COUNT(Type)
  FROM pet
  ORDER BY Type DESC;
  </code></pre>