title: Select movie with multiple genre
body: <p>I have 3 database:</p>
  <pre><code>anime : id, name, year
  genre : id, name
  anime_genre : anime_id, genre_id
  </code></pre>
  <p>I want to get all movies with two or more specific genres. For example movie1 and movie2 drama and comedy. For example, I'm looking for a movie with genres of comedy and drama and I need to receive all movies all movies with both these genres.
  I tried to do like this, but I need both genres:</p>
  <pre><code> select a.* from anime a where a.id IN 
   (SELECT ag.anime_id from anime_genre ag join genre g on ag.genre_id 
   WHERE ag.genre_id in (1,4))
  </code></pre>
  <p>Database:<br />
  <a href="https://i.stack.imgur.com/Lwjky.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Lwjky.png" alt="Database" /></a></p>