title: select group of rows that matches all its associated items to a list
body: <p>I got a table:</p>
  
  <pre><code>id|name
  ------
  1|Tom
  1|Lucy
  1|Frank
  2|Lucy
  2|Frank
  3|Frank
  4|Jane
  5|Robert
  6|John
  </code></pre>
  
  <p>Need result of id's where all the names associated with a specific id match to the list</p>
  
  <p>The list is ('Lucy','Frank','Jane','Robert','Brandon').</p>
  
  <p>I've tried this:</p>
  
  <pre><code>select id 
  from table 
  group by id 
  having name in('Lucy','Frank','Jane','Robert','Brandon')
  </code></pre>
  
  <p>Obtained result:</p>
  
  <pre><code>1
  2
  3
  4
  5
  </code></pre>
  
  <p>Desired Result:</p>
  
  <pre><code>2
  3
  4
  5
  </code></pre>
  
  <p>What's excluded: the count(distinct id) > 2000
  the list contains 200 names and each id is associated with at least 1 name</p>