title: Counting multiple fields in SQL
body: <p>I have a table listing People's First Names, their Age, and their favorite color.</p>
  
  <p>I need to create a query in SQL (In access) that counts how many people like Red, and how many people like Yellow.</p>
  
  <p>So far I have written this:</p>
  
  <pre><code>SELECT COUNT (*) as "People who like Yellow or Red"  
  FROM Table1  
  WHERE Table1.[Favorite Color]='Red'  
  OR Table1.[Favorite Color]='Yellow';  
  </code></pre>
  
  <p>But this returns the TOTAL count of people who like Yellow/Red (In my case, 5)</p>
  
  <p>I have three people who like Yellow, and two who like Red, how can I show those counts independently of each other?</p>