title: AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?)
body: <p>I have the impala query:</p>
  
  <pre><code>select id,zip,income
  from zipcode_incomes
  group by income
  having income&gt;avg(income)
  </code></pre>
  
  <p>but i am getting error, AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?). What mistake did I make?</p>