title: Count function in Oracle
body: <p>The question I'm struggling with is this:</p>
  
  <p>I have a list of helicopter names in different charters and I need to find out WHICH helicopter has the least amount of charters booked. Once I find that out I need to ONLY display the one that has the least.</p>
  
  <p>I so far have this:</p>
  
  <pre><code>SELECT Helicopter_Name 
         , COUNT (Distinct Charter_NUM)
  FROM Charter_Table
  GROUP BY Helicopter Name
  </code></pre>
  
  <p>This is where I am stuck.  I realise MIN could be used to pick out the value that is the smallest but I am not sure how to integrate this into the command.</p>
  
  <p>Something like <code>Where MIN = MIN Value</code></p>
  
  <p>I'd really appreciate it.</p>