title: "AMOUNT1" is not valid in the context where it is used
body: <p>I'm executing the the following query in DB2:</p>
  
  <pre><code>select  
    SUM (orders.totalproduct
        +orders.TOTALTAX
        +orders.totalshipping
        -orders.totaladjustment) as amount1 
  from 
    orders  
  where 
    amount1&gt;10000
  </code></pre>
  
  <p>The query is not executed, I get this exception instead:</p>
  
  <blockquote>
    <p>"AMOUNT1" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.96 SQL Code: -206, SQL State: 42703</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>