title: Converting an existing SQL statment to a JPQL statement
body: <p>I have problem with converting an existing SQL statment to a JPQL statement.</p>
  
  <p>SQL statement is: </p>
  
  
  
  <pre><code>select SeatsID from cinema.seats a 
  where a.SeatsID not in 
      (select SeatID FROM cinema.reservation_seats s, cinema.reservation r 
      where s.ReservationID = r.ReservationID and r.ShowID = 1)
  </code></pre>
  
  <p>Which finds all free seats for show with <code>ID = 1</code>.
  But I can not properly write JQPL statement.</p>
  
  <p>Could you help me? </p>