title: How can I search by two continuous rows in SQL?
body: <p>Given the SQL table</p>
  
  <pre><code>id     date       employee_type  employee_level
  1   10/01/2015        other            2
  1   09/13/2011      full-time          1
  1   09/25/2010       intern            1
  2   09/25/2013      full-time          3
  2   09/25/2011      full-time          2
  2   09/25/2008      full-time          1
  3   09/23/2015      full-time          5
  3   09/23/2013      full-time          4
  </code></pre>
  
  <p>Is it possible to search for ids that have one row with employee_type "intern", and the row above it in the table (same id with later date) with employee_type "full-time". </p>
  
  <p>In this case, id 1 meets my requirement.</p>
  
  <p>Thanks a lot!</p>