title: Where clause that returns values that have meet at least two of three criteria
body: <p>I am trying to write a where clause that will find people who have meet at least two of three criteria. 
  This is an example</p>
  
  <pre><code>   SELECT *
     FROM Personal
     WHERE
     [State] = 'Tx' or [City] = 'Austin' or [Gender] = 'Male'
  </code></pre>
  
  <p>So It should return anyone who Lives in Texas and Austin or Lives in Texas and is Male and so on, but not someone who just lives in Texas, they have to meet at least two of the criteria</p>
  
  <p>My real query can have more criteria and also include a greater than two or exactly two and so on.</p>
  
  <p>Thanks in advance</p>