title: I am confused seeing this error: Incorrect syntax near the keyword 'WHERE' mysql
body: <p>Where did I do wrong?</p>
  
  <pre><code>SELECT constituency,party, votes
  FROM    (SELECT constituency,party, votes, RANK() OVER (ORDER BY votes DESC) as posn
          FROM ge WHERE posn =1 and yr  = 2017 )
  WHERE constituency BETWEEN 'S14000021' AND 'S14000026'
  ORDER BY constituency,votes DESC
  </code></pre>