title: SQL Query: comparison with condition
body: <p>I have a table which looks as follows (simplified):</p>
  
  <p><strong>name | status</strong><br>
  app-1  | start<br>
  app-1  | run<br>
  app-1  | run<br>
  app-1  | run<br>
  app-1  | finish<br>
  app-2  | start<br>
  app-2  | run<br>
  app-2  | run   </p>
  
  <p>now, I would like to filter all apps, that have "start" for a status AND no "finish". For the example above, the result is supposed to be "app-2".</p>
  
  <p>I have no clue how to do the comparison while additionally use a condition...it really gives me some hard time. I hope someone can help me with it?!</p>