title: How to select id's that have rows for all values from a set
body: <p>I want to select all Id from a table that have rows for both programs 'basketball' and 'football'</p>
  
  <p>Given a table like this:</p>
  
  <pre><code>Id  program
  1   basketball
  2   football
  3   basketball
  2   basketball
  1   football
  4   football
  5   basketball
  </code></pre>
  
  <p>How can I get a result like this:</p>
  
  <pre><code>id
  1
  2
  </code></pre>