title: count on multiple joined tables
body: <p>I have the following tables:</p>
  
  <pre><code>Players
  - id
  - name
  
  Games
  - id
  - game_type_id
  - season_id
  
  
  Goals
  - player_id
  - game_id
  
  Assists
  - player_id
  - game_id
  </code></pre>
  
  <p>I've been struggling trying to build a query/view that will give me the players' goal and assist counts for each season and game type. It's important to each player is listed for each season and game type, whether they have goals/assists or not. </p>
  
  <p>The query will be used to create a view. Can it be done in one query?</p>
  
  <p>UPDATE: Here's an <a href="http://sqlfiddle.com/#!2/8312c" rel="nofollow">SQL Fiddle</a> with some production sample data. </p>