title: Setting 0 as null value in Oracle SQL throwing "%s: invalid identifier"
body: <p>In OracleSQL, I am trying to add a colunm to a table that holds the amount of times the <code>APPLICANT</code> is found in <code>APPLIES</code> (Identified by <code>anumber</code>).</p>
  <p>I started with:</p>
  <pre><code>ALTER TABLE APPLICANT
  ADD numapp NUMBER(2);
  </code></pre>
  <p>and then used an insert statement:</p>
  <pre><code>INSERT INTO APPLICANT(numapp) SELECT COUNT(anumber), NVL(bonus, 0) FROM APPLIES GROUP BY anumber;
  </code></pre>
  <p>I have been told that the <code>NVL</code> statement is supposed to set any null value to 0 in the insert, but I haven't been able to get it working, as I get the following error whenever trying to run it.</p>
  <pre><code>SQL Error: ORA-00904: &quot;BONUS&quot;: invalid identifier
  00904. 00000 -  &quot;%s: invalid identifier&quot;
  </code></pre>
  <p>I am very new to SQL so apologies if this is a very obvious fix that I'm missing.</p>