title: SQL Left join with having clause
body: <p>So I am having this sql code:</p>
  
  <pre><code>select stone_number,stone_size,stone_shape,stone_weight 
  from stone
  left Join stone_price stp on stp.id_stone = stone.id_stone
  group by stone_number,stone_size,stone_shape,stone_weight 
  having  avg(stp.price) &lt; stp.price;
  </code></pre>
  
  <p>Sqldeveloper returns: not a group by expression tho I still have group by in my code.
  My goal is to get stone items which price is higher then average price of all stones.</p>