title: AVG in HiveQL - Error when I try to get the average of columns
body: <p>I'm trying to get the total average of temperature(one column on my DB from table w) of each <code>StationID</code> (one column on my DB from table s).</p>
  
  <p>My query:  </p>
  
  <pre><code>SELECT s.zipcode AS Zipcode, AVG(w.precip) AS Preciptation FROM stationData s JOIN weatherReport w ON s.stationid = w.stationid;
  </code></pre>
  
  <p>Error: </p>
  
  <blockquote>
    <p>Your query has the following error(s):<br>
    OK FAILED: SemanticException [Error 10025]: Line 1:7 Expression not in GROUP BY key 'zipcode'<br>
    ok failed: semanticexception [error 10025]: line 1:7 expression not in group by key 'zipcode'</p>
  </blockquote>