title: SQL - how to select rows that do not contain a certain ID
body: <p>So I have the table flag_counts with the following columns:</p>
  
  <pre><code>flag_id content_id
  1       10
  2       10
  2       11
  </code></pre>
  
  <p>and the following query</p>
  
  <pre><code>SELECT flag_id, content_id FROM flag_counts
  WHERE flag_id != 1
  </code></pre>
  
  <p>and of course it returns</p>
  
  <pre><code>flag_id content_id
  2       10
  2       11
  </code></pre>
  
  <p>How can I change my query so that it returns all content_ids that were not flagged with "1". In this example, I would like the query to return only the last row of the table since the content_id "10" was flagged once with "1".</p>