title: Postgresql Syntax error at or near "where"
body: <p>I am getting the error </p>
  
  <blockquote>
    <p>syntax error at or near "where" LINE 5: where zip in (select zipcode
    from zips where city = 'Sacra</p>
  </blockquote>
  
  <p>when I try to run this code.</p>
  
  <pre><code>update listings
  set price = CASE WHEN (listings.price IS NOT NULL) THEN (price * 
  (((100+(select price_change from zips where zips.zipcode=listings.zip))/100)))
  where zip in (select zipcode from zips where city = 'Sacramento');
  </code></pre>
  
  <p>Does anybody see any easy to fix errors? or did I come up with some garbage code?</p>