title: sql finding movie(s) with specific genres
body: <pre><code>select 
    film.title
  from film
    left outer join filmitem ON film.filmid = filmitem.filmid
    left outer join filmgenre ON filmitem.filmid = filmgenre.filmid
  where
    film.title = title and filmgenre.genre NOT IN (
      select genre from genre
      where genre != 'Comedy' and genre != 'Horror')
  group by title;
  </code></pre>
  
  <p>I want to find movies that only contains the genres 'Comedy' and 'Horror'. When I run this query I get movies that are comedy and other genders, but I want to exclude the other genders and only get the movies that are only comedy and horror. Any suggestions please?</p>