title: How do I count scores over 90 in sql
body: <p>I want to count scores over 90, but this ends up counting the total rows</p>
  
  <pre><code>select g.score as score
        ,count(case when g.score&gt;=90 then 1 else 0 end) over () as passed
  from grades g
  </code></pre>
  
  <p>If my data is</p>
  
  <pre><code>100
  45
  90 
  100
  </code></pre>
  
  <p>it should show 3, but instead it shows 4</p>