title: If Having More Than x Then Where Statement
body: <p>Is there anyway to have HAVING and WHERE clauses work in conjecture with each other?  ie psuedocode:</p>
  
  <pre><code>CASE
     HAVING count(children) &gt; 3 THEN WHERE nationality = 'Mexican'
     HAVING count(children) = 2 THEN WHERE nationality = 'American'
     HAVING count(children) = 1 THEN WHERE nationality = 'Japanese'
  END
  </code></pre>