title: "Invalid use of group function" with no group function used
body: <p>Anyone has an idea why I get this error message:</p>
  
  <blockquote>
    <p>Lookup Error - MySQL Database Error: Invalid use of group function</p>
  </blockquote>
  
  <p>for the following query?</p>
  
  <pre><code>select * from users u where u.CreationDate BETWEEN min(u.CreationDate) AND 
  DATE_ADD(min(u.CreationDate), INTERVAL 1 YEAR)
  </code></pre>
  
  <p>I have to group function in the query!</p>