title: what is sql query of below table?
body: <pre><code>CREATE TABLE table1(kid char(2),color varchar(9));
  
  INSERT INTO table1('k1'.'yello');
  INSERT INTO table1('k1'.'red');
  INSERT INTO table1('k2'.'yello');
  INSERT INTO table1('k2'.'blue');
  INSERT INTO table1('k3'.'yello');
  </code></pre>
  
  <p>Q: Display <code>kid</code> of table1 which has <code>color</code> values yellow and red (both of them)?</p>
  
  <p>What is sql query?</p>