title: Beginning SQL group by and AVG
body: <p>I am trying to pull information from two columns titled clientstate and clientrevenue in my table. I want clientstate to show up as the state, and have only distinct names in it, and under client revenue I want the average revenue per state, and that will only show up if there are at least two clients from that state. I am very new at this, so what I have is pretty iffy:</p>
  
  <pre><code>SELECT clientstate, clientrevenue
  FROM client
  GROUP BY clientrevenue
  HAVING COUNT (*) &gt;=2;
  </code></pre>
  
  <p>Where am I going wrong here?</p>