title: No results for AND operator in sql query
body: <p>Why am i not getting answer if i use and operator in my query?</p>
  
  <p><strong>MY TABLE</strong></p>
  
  <pre><code>+-----------+--------+----------+------+----------+-------------+--------------+
  | course_id | sec_id | semester | year | building | room_number | time_slot_id |
  | BIO-301   | 1      | Summer   | 2010 | Painter  | 514         | A            |
  | CS-101    | 1      | Fall     | 2009 | Packard  | 101         | H            |
  | CS-101    | 1      | Spring   | 2010 | Packard  | 101         | F            |
  | CS-190    | 1      | Spring   | 2009 | Taylor   | 3128        | E            |
  +-----------+--------+----------+------+----------+-------------+--------------+
  </code></pre>
  
  <p><strong>SQL QUERY WITH OUTPUT</strong></p>
  
  <pre><code>MariaDB [university2038]&gt; 
  
      select course_id from section where semester='Fall' AND semester='Spring';
  
  Empty set (0.00 sec)
  </code></pre>