title: Max value of count in oracle
body: <p>I have these tables, Orders Table:</p>
  
  <pre><code>Name       Null?    Type  
  ORDER_ID  NOT NULL  NUMBER(5)  
  CUSTOMER_ID         NUMBER(8)  
  SHIPMENT_METHOD_ID  NUMBER(2)  
  </code></pre>
  
  <p>and Shipment_method Table:</p>
  
  <pre><code>Name               Null?      Type  
  SHIPMENT_METHOD_ID  NOT NULL  NUMBER(2)  
  SHIPMENT_DESCRIPTION          VARCHAR2(80)  
  </code></pre>
  
  <p>I'm trying to get the most used shipping method based on the orders, and I'm kind of a beginner here so I need some help.
  I'm thinking if it's possible to have MAX(count(order_id)) but how can I do that for each shipment_method_id?</p>