title: how to Use created SQL variable in the same query
body: <p>I have the following query:</p>
  <pre><code>   SELECT target,
     
     CASE
         WHEN var_10 &gt;1.5 AND var_10 &lt;2.5 THEN 1 
     END as var_10_bck,
  </code></pre>
  <p>Then I want to use this new created variable &quot;var_10_bck&quot; in the same query that continues as :</p>
  <pre><code>   CASE
         WHEN var_10_bck &lt;2 THEN 0
     END as var_10_new
  
     FROM database
  </code></pre>