title: ORA-00904 invalid identifier error
body: <p>I get ORA-00904 'c' invalid identifier error. What is wrong with this alias ?</p>
  
  <pre><code>select NO, count(JOINT_NO) as c
  from JOINT
  WHERE HOLDER = 'Y' AND JOINT.c &gt; 1
  GROUP BY NO;
  </code></pre>