title: SQL - how to output a list of objects with only one certain attribute?
body: <p>For example we have:</p>
  
  <pre><code>name fruit
  -------------
  bill apple
  bill orange
  lily apple
  emma orange
  </code></pre>
  
  <p>I only want to output a list of people who have apple as their ONLY attribute. so the list would only include Lily. </p>
  
  <p>How would I do that?</p>
  
  <p>Thanks guys!</p>