title: Using at least in SQL Query
body: <p>I have been working on my SQL work for the following. I am able to write a query for the following using "AND" but i am able to come up with using "at least" in query.</p>
  
  <p><strong>Find the sids of suppliers who supply a red part and a green part.</strong></p>
  
  <pre><code>Select s.sid from suppliers s, catalog c, parts p
  where s.sid=c.sid and c.pid=p.pid and p.color='Red'
  intersect
  Select s.sid from suppliers s, catalog c, parts p
  where s.sid=c.sid and c.pid=p.pid and p.color='Green';
  </code></pre>
  
  <p>How to write a query using <code>atleast</code> for the question like </p>
  
  <p><strong>"Find the sids of suppliers who supply at least two red parts and at least two green parts."</strong></p>