title: Getting ID with no Incomplete Status in SQL
body: <p>I have these data below to play with, and I want to pull only the ID/s with no Incomplete or 'I' status.</p>
  
  <pre><code>ID  SUBJECT   STATUS
  1   Math        C
  1   Physics     C
  1   Chemistry   I
  2   Math        I
  2   Physics     C
  2   Chemistry   I
  3   Math        C
  3   Physics     C
  3   Chemistry   C
  </code></pre>
  
  <p>How do you code this in SQL wherein only ID #3 gets pulled since it is the only one without 'I' in its status. </p>