title: Adding max(count) and min(count) to query
body: <p>I am trying to add max and min to the query below:</p>
  
  <pre><code>SELECT category, COUNT(distinct VIN) COUNT
  FROM stock
  group by category
  order by category ASC
  </code></pre>
  
  <p>The desired results are to show the category with the most items in the count and to show the category with the least items in the count.</p>
  
  <p>CURRENT OUTPUT:</p>
  
  <pre><code>CATEGORY COUNT
  Sedan    25
  SUV      15
  TRUCK    15
  AWD      10
  </code></pre>
  
  <p>DESIRED OUTPUT:</p>
  
  <pre><code>CATEGORY COUNT
  Sedan    25
  AWD      10
  </code></pre>
  
  <p>I basically want to show the maximum count which in this example would be SEDAN and the minimum category count which would be AWD</p>
  
  <p>I believe this would require a <code>HAVING</code> statement with a nested sub-query, any help would be much appreicated</p>
  
  <p>I am using Oracle 11g</p>