title: To confirm, Is this a type of anti-join?
body: <p>We know that an anti-join is a type of Join where we try to get unmatched rows. I am faced with the following question:</p>
  
  <blockquote>
    <p>Find the titles of all movies that have no ratings.</p>
  </blockquote>
  
  <p>I've developed the following SQL query to satisfy that:</p>
  
  <pre><code>select Movie.title
  from Movie
  where Movie.mID not in (select Rating.mID from Rating)
  </code></pre>
  
  <p>I have ran into the term anti-join earlier, and I just wanted to confirm that this was indeed a anti-join. In particular this is a right anti-join.</p>