title: Do all columns in a SELECT list have to appear in a GROUP BY clause
body: <p>My lecturer stated:</p>
  
  <p><strong>All column names in SELECT list must appear in GROUP BY clause unless name is used only in an aggregate function</strong></p>
  
  <p>I'm just wanting some confirmation of this as I cannot think of a logical explanation as to why it should be true...</p>