title: SQL - MS Access - if statement
body: <p>I have the following table:</p>
  
  <pre><code>Table1
  Color  Room type
  Black  Large
  White  Large
  White  Small
  Black  Medium
  Black  Small
  </code></pre>
  
  <p>I want to run a query that:</p>
  
  <ul>
  <li>If the data shows White occurs more often than Black for colors of <strong>large rooms</strong> then the result would be White</li>
  <li>If the data shows Black occurs more often than White then the result would be black.</li>
  <li>If the data shows Black occurs the same amount as White then the result would be unidentified.</li>
  </ul>
  
  <p>Notice that my query is more complicated than that and it has other columns and many tables, but I just want to add the column that specifies if large rooms are mostly white or black.</p>