title: Select row matching a condition if no other rows match a different condition
body: <p>Very basic, but didn't know what this type of query is called...I want a query that will basically do this (pseudo-SQL):</p>
  
  <pre><code>SELECT name 
    FROM Table  
   WHERE activity_status != 'active'  
     AND there are no rows with that same name where activity_status = 'active'  
  </code></pre>
  
  <p>(in other words, return names of the inactive only when not one with that name is active)</p>
  
  <p>This will be used to allow users an option to reactivate inactive items, but I want to query the db to make sure that item isn't already active.</p>