title: MySQL Workbench reports "is not valid at this position for this server version" error
body: <p>For the following SQL query:</p>
  
  <pre><code>SELECT COUNT (distinct first_name) from actor;
  </code></pre>
  
  <p>I receive the following error message:</p>
  
  <pre><code>"SELECT" is not valid at this position for this server version, expecting: '(', WITH
  </code></pre>
  
  <p>I am a total newbie at SQL. How do I resolve this error?</p>
  
  <p>I put the exact same line at another PC with the exact same schema and it worked fine.</p>