title: How come my count() passes evaluation?
body: <p>I am fairly new at SQL and I am trying to create a query that tries to determine in which countries only 3 specific languages (spanish,italian,german) are spoken and no other languages.</p>
  
  <pre><code>select country
  from langusage
  group by country
  having count(case when language in ('spanish','german','italian') then 1 else 5 end)=3
  </code></pre>
  
  <p>The output are all countries that have at least 1 of the aforementioned languages . How come they pass the '=3' test? </p>