title: I want extract from Json and count in HQL
body: <p>I want extract from Json and count in HQL
  JSON is like </p>
  
  <pre><code>{
      "online_pay": 1,
      "is_settle": 1,
      "period": "00:00-23:59",
      "policy_detail": [{
          "price": 10.0,
          "discounts": [{
              "agent_charge": 0.0,
              "code": 1,
              "mt_charge": 0.0,
              "type": "default",
              "poi_charge": 1.0,
              "discount": 1.0
          }]
      }, {
          "price": 15.0,
          "discounts": [{
              "agent_charge": 0.0,
              "code": 1,
              "mt_charge": 0.0,
              "type": "default",
              "poi_charge": 2.0,
              "discount": 2.0
          }]
      }, {
          "price": 20.0,
          "discounts": [{
              "agent_charge": 0.0,
              "code": 1,
              "mt_charge": 0.0,
              "type": "default",
              "poi_charge": 3.0,
              "discount": 3.0
          }]
      }, 
      "type": 2
  }
  </code></pre>
  
  <p>I tried       </p>
  
  <pre><code>regexp_extract(detail,'price\"\:[0-9]+')
  </code></pre>
  
  <p>but it's only bring me       price": 10.0
  I want then all</p>