title: SQL GROUP BY and HAVING issue
body: <p>I'm learning some sql and I'm doing some exercises to learn better and I'm having trouble with the GROUP BY function.
  So I have a some basic Tables of Actors(Title, Year, CharacterName, Name) and Movies(Title, Year). My task is to list the Actors name who played more than one character in the same movie.
  This is the code I tried:</p>
  
  <pre><code>SELECT A.Name
  FROM Actors A, Movies M
  WHERE A.Title = M.Title AND A.Year = M.Year
  GROUP BY A.CharacterName HAVING COUNT(*) &gt; 1;
  </code></pre>
  
  <p>However I get this error:</p>
  
  <blockquote>
    <p>error 1055(42000):Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'new.A.Name' which is not functionally dependent on columns in GROUP BY clase; this is incompatible  with sql_mode = only_full_group_by.</p>
  </blockquote>