title: ORA-907: missing right parenthesis and am I doing this right?
body: <p>I'm kind of new to SQL.</p>
  <pre><code>SELECT EMP_NAME, MAX(count(CONTRACT_CLIENT)
  
  FROM CONTRACT JOIN EMPLOYER ON (CONTRACT_ID = EMP_ID)
  
  WHERE EMP_ID = CONTRACT_ID;
  </code></pre>
  <p>it comes up with missing right parenthesis. Feel completely lost.</p>