title: SQL SELECT with m:n relationship
body: <p>I have m:n relationship between users and tags. One user can have m tags, and one tag can belong to n users. Tables look something like this:</p>
  
  <pre><code>USER:
  ID
  USER_NAME
  
  USER_HAS_TAG:
  USER_ID
  TAG_ID
  
  TAG:
  ID
  TAG_NAME
  </code></pre>
  
  <p>Let's say that I need to select all users, who have tags "apple", "orange" AND "banana". What would be the most effective way to accomplish this using SQL (MySQL DB)?</p>