title: MySQL AVG query help
body: <p>I have this query which works perfectly:</p>
  
  <pre><code>SELECT cp.*
  FROM CustPrimaryQ cp
      JOIN Customer c ON cp.CxID = c.CustomerID
      JOIN SacCode sc ON sc.SacCode = c.SacCode
  WHERE sc.ResellerCorporateID = 392
  </code></pre>
  
  <p>However I am trying to modify it to calculate an average.</p>
  
  <p>Each row of the CustPrimaryQ table has a field called QScore and it's this field I want to find out the total average of.</p>
  
  <p>In other words if there are 10 rows in CustPrimaryQ I want the Average QScore for the 10 rows.</p>
  
  <p>Any help would be much appreciated.</p>