title: how to get total order price using mysql?
body: <p>there are two tables one is order and 2nd one is order_details respectively,</p>
  
  <p><strong><code>order</code></strong> table</p>
  
  <pre><code>order_id    order_name
  1           shoes
  2           wallet
  3           socks
  4           bats
  </code></pre>
  
  <p><strong><code>order_details</code></strong> table</p>
  
  <pre><code>order_details_no  order_id(foregin key)  order_price
          1              1                   25
          2              1                   55
          3              2                   65
          4              4                   30
          5              4                   60
  </code></pre>
  
  <p>My question is, I want result set which includes order_id, order total price in ascending order (eg order 1 total is 80,order 4 total is 90 )   </p>
  
  <p>How to get this ?</p>