title: How can i get whole shop list in SQL
body: <p>I would like to check each store's average score.</p>
  
  <p>my ‘shop’ table is
  <a href="https://i.stack.imgur.com/fu4j2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fu4j2.png" alt="enter image description here"></a></p>
  
  <p>my ‘order’ table is
  <a href="https://i.stack.imgur.com/03WKO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/03WKO.png" alt="enter image description here"></a></p>
  
  <p>My SQL is :</p>
  
  <pre><code>SELECT a.id,a.name,AVG(b.point) as point
  from shop a
  LEFT JOIN order b on a.id=b.shop_id
  WHERE b.point&lt;&gt;0
  GROUP BY(b.shop_id) 
  </code></pre>
  
  <p>but this SQL only can check out the shop had point in ‘order’ table.</p>
  
  <p>How can i get whole shop list in SQL?</p>