title: calculate spectators sum from table
body: <p>Table Games</p>
  
  <pre><code>Home |  Visitor    | Spectators
  -----------------------------------
  a    |    b        |   12
  b    |    c        |   15  
  a    |    c        |   32
  b    |    a        |   3
  c    |    a        |   8
  </code></pre>
  
  <p>Table Teams</p>
  
  <pre><code>id  |  name
  --------------
  a   |  TeamA
  b   |  TeamB
  c   |  TeamC
  </code></pre>
  
  <p>Now I need to calculate each teams total spectators (home + visitor)</p>
  
  <ul>
  <li>A = 12+12+3+8</li>
  <li>B = 12+15+3</li>
  </ul>