title: Group by query in Oracle
body: <p>I have a table with create_dt and order_type, now I want count of different orders on different dates. </p>
  
  <p>For e.g. on 22nd March, 2016 I have orders with count(each count means different row) of orders of type_1(2), type_2(3) and no 23rd March, 2016 I have type_1(5) and type_2(3) ordered.</p>
  
  <p>The expected output should be </p>
  
  <pre><code>Order_type  count(order_type) create_dt
  type_1      2                 22-03-2016
  type_1      5                 23-03-2016
  type_2      3                 22-03-2016
  type_2      3                 23-03-2016
  </code></pre>
  
  <p>Can someone help here in this?</p>