title: sports league database design
body: <p>I'm developing a database to store statistics for a sports league.
  I'd like to show several tables:</p>
  
  <ul>
  <li>league table that indicates the position of the team in the current and previous fixture</li>
  <li>table that shows the position of a team in every fixture in the championship</li>
  </ul>
  
  <p>I have a matches table:</p>
  
  <ul>
  <li>Matches (IdMatch, IdTeam1, IdTeam2, GoalsTeam1, GoalsTeam2)</li>
  </ul>
  
  <p>With this table I can calculate the total points of every team based on the matches the team played. But every time I want to show the league table I have to calculate the points.</p>
  
  <p>Also I have a problem to calculate in which position classified a team in the last 10 fixtures cause I have to make 10 queries.</p>
  
  <p>To store the league table for every fixture in a database table is another approach, but every time I change a match already played I have to recalculate every fixture from there...</p>
  
  <p>Is there a better approach to solve this problem?</p>
  
  <p>Thanks</p>