title: SQLite multiple conditions
body: <p>Suppose I have the following TABLE called "fruits" with the fields "FRUIT", "STATUS", and "DATE"</p>
  
  <pre><code>FRUIT       STATUS      DATE
  ----------  ----------  ----------
  apple       ADDED       2017-07-01
  orange      ADDED       2017-07-03
  peach       ADDED       2017-07-03
  apple       REMOVED     2017-07-14
  pear        ADDED       2017-07-11
  peach       REMOVED     2017-07-15
  </code></pre>
  
  <p>How can I query for all fruits that have been both 'ADDED' and 'REMOVED'? </p>