title: SQL CASE WHEN bigger than
body: <p>I've been searching a lot and in the examples everything looks fine, but in fact it doesn't.
  I want to calculate the salary increase dependently on the amount. Missing keyword error appears.</p>
  
  <pre><code>SELECT o.operator_name,
         o.salary,
  (CASE o.salary
   WHEN o.salary &lt; 500 THEN o.salary * 1.35
   WHEN o.salary &gt;= 500 AND o.salary &lt; 1000 THEN o.salary * 1.15
   WHEN o.salary &gt;= 1000 AND o.salary &lt; 1500 THEN o.salary * 1.05 
   END) AS "Increase"
  FROM operators o;
  </code></pre>
  
  <p>I tried with IF ELSIF, I got "FROM is not where is expected".</p>