title: Finding a calculated ratios less than the average (SQL)
body: <pre><code>SELECT 
      PlayerName, ROUND(SUM(A)/SUM(TO),2) AS ATORatio
  FROM 
      Players_t 
  INNER JOIN 
      GameStats_t ON Players_t.JerseyNumber=GameStats_t.JerseyNumber
  WHERE 
      ATORatio &lt; (SELECT SUM(A)/SUM(TO) FROM GameStats_t)
  GROUP BY 
      PlayerName;
  </code></pre>
  
  <p>I need to return all players who have an <code>ATORatio</code> less than the average. Why doesn't this code work?</p>