title: How do i get result which is bigger than an avg ( avg that i don't have )?
body: <p>I am very new to PostgreSQL and to this website. I need your help with this, please.</p>
  
  <p>I need to get all months with more than average rain amount.</p>
  
  <p>I tried this but its not working, may anyone explain?</p>
  
  <pre><code>Select month, rain from weather 
  where rain &gt; avg(rain)
  group by month , rain;
  </code></pre>
  
  <p>Thanks a lot.</p>