title: SQL AVG function on multiple tables
body: <p>I have two more or less identical tables:</p>
  
  <p>test_score</p>
  
  <pre><code>id  int(11) PK AI
  user_id int(11) 
  module_id   int(11) 
  score   double 
  number_correct  int(11) 
  correct_total   int(11) 
  timestamp   datetime 
  phase_id    int(11) 
  medal_id    int(11) 
  team_id int(11) 
  status_id   int(11) 
  </code></pre>
  
  <p>And</p>
  
  <pre><code>id  int(11) PK AI
  user_id int(11) 
  module_id   int(11) 
  score   double 
  number_correct  int(11) 
  correct_total   int(11) 
  timestamp   datetime 
  phase_id    int(11) 
  medal_id    int(11) 
  team_id int(11) 
  status_id   int(11) 
  </code></pre>
  
  <p>Now the reason for these two being so identical is that they contain data from each of their own component in my system.</p>
  
  <p>Now i want to use the <code>AVG()</code> function to find the average score of these two tables combined.</p>
  
  <p>is this possible?</p>