title: Filter out specific value without excluding the NULL rows
body: <p>I have the following table and I want to filter out a specific value but keeping the null (empty) rows.</p>
  <pre><code>category       sell
  Apple           1
  Orange          3
  Banana          2
  null            1
  Orange          2
  null            1
  </code></pre>
  <p>I tried different ways but the query kept filtering out the <em>null</em> rows. For example, I only want to filter out the rows with the orange, the output table should be:</p>
  <pre><code>category       sell
  Apple           1
  Banana          2
  null            1
  null            1
  
  SELECT *
  FROM table AS t 
  WHERE t.&quot;sell&quot;  NOT IN ('Orange') 
  </code></pre>
  <p>I also tried with</p>
  <pre><code>WHERE t.&quot;sell&quot;  != 'Orange'
  </code></pre>
  <p>OR</p>
  <pre><code>WHERE t.&quot;sell&quot;  NOT LIKE '%Orange%'
  </code></pre>
  <p>All of the returned results exclude the rows with the null value. Any suggestions would be really appreciated.</p>