title: SQL Query to find the ID with highest difference of contents
body: <p>I'm a newbie to SQL (Server) and the following question is really making me clueless. </p>
  
  <pre><code>ID  Order Type    
  =====================    
  26  Automatic Orders    
  26  Backend Orders    
  41  Automatic Orders    
  58  Automatic Orders    
  86  Automatic Orders    
  86  Automatic Orders    
  86  Automatic Orders    
  111 Automatic Orders    
  104 Automatic Orders    
  112 Backend Orders    
  112 Backend Orders    
  119 Backend Orders    
  119 Backend Orders    
  119 Backend Orders
  </code></pre>
  
  <p>Now it is asked to find "The hotel which has more number of automatic orders and less backend orders ?"</p>
  
  <p>Though I was able to answer most of the questions came along with this, I'm really not getting what should I do to crack this!</p>