title: How can I get multiple averages from multiple rows using Mysql
body: <p>I am attempting to get the average rating (1-10) for each of 6 games that were rated.</p>
  
  <p>Here is an example of the table:
  <img src="https://i.stack.imgur.com/hbF9W.png" alt="enter image description here"></p>
  
  <p>I can select the average of one of the 6 games like this:</p>
  
  <pre><code>SELECT ROUND(AVG(overallRating), 0), COUNT(*) AS Total, gameID
  FROM gameSurvey
  WHERE gameID = 1
  </code></pre>
  
  <p>I want to retrieve the average rating of all 6 games?</p>