title: Show count value 0 when row doesn't exist MYSQL
body: <p>I have 2 tables Game and Bet. I want to count the number of bets for each game. However my current query doesn't include a game when there is no bet for that specific game id.</p>
  
  <p>here is my current query:</p>
  
  <pre><code>SELECT g.*, 
         Count(*) AS participants 
  FROM   game g, 
         bet b 
  WHERE  b.game_id = g.id 
         AND USER = ? 
  GROUP  BY g.id 
  </code></pre>
  
  <p>So to make it more clear lets say I have 3 rows in my Game table. There are 4 bets for game1 , 2 bets for game2 and there is no row associated with game3 in Bet table. The result should be:</p>
  
  <pre><code>g1  4
  g2  2
  g3  0
  </code></pre>
  
  <p>I'd appreciated any help.              </p>