title: SQL - Multiply values in same table
body: <p>I have the following code:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>SELECT ConsumerID, Product,
         (frequency * Product_Value) as Value_productA
         (frequency * Product_Value) as Value_productB
         (frequency * Product_Value) as value_productC
  From Table1</code></pre>
  </div>
  </div>
  </p>
  
  <p>The table1 looks like that:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>ConsumerID | Product | Product_value | frequency | value_productA | value_productB | value_productC
  -----------------------------------------------------------------
  001 | productA | 5$ | 2 | | | |
  001 | productB | 7$ | 4 | | | |
  001 | productC | 9$ | 6 | | | |
  002 | productA | 5$ | 2 | | | |
  002 | productB | 7$ | 4 | | | |
  002 | productC | 9$ | 6 | | | |
  
  
  Expected Bevaviour:
  
  ConsumerID | Product | Product_value | frequency | value_productA | value_productB | value_productC
  -----------------------------------------------------------------
  001 | productA | 5$ | 2 |10$ |    |    |
  001 | productB | 7$ | 4 |    |28$ |    |
  001 | productC | 9$ | 6 |    |    |54$ |
  002 | productA | 5$ | 2 | 10$|    |    |
  002 | productB | 7$ | 4 |    |28$ |    |
  002 | productC | 9$ | 6 |    |    |54$ |
  
  
  Current behaviour:
  
  ConsumerID | Product | Product_value | frequency | value_productA | value_productB | value_productC
  -----------------------------------------------------------------
  001 | productA | 5$ | 2 |10$ |10$ |10$ |
  001 | productB | 7$ | 4 |28$ |28$ |28$ |
  001 | productC | 9$ | 6 |54$ |54$ |54$ |
  002 | productA | 5$ | 2 |10$ |10$ |10$ |
  002 | productB | 7$ | 4 |28$ |28$ |28$ |
  002 | productC | 9$ | 6 |54$ |54$ |54$ |</code></pre>
  </div>
  </div>
  </p>
  
  <p>The idea is to calculate the value for each client &amp; product - Meaning frequency*product_value. The example code calculates the SUM correctly but writes it in every fiels instead of only in the value_productX field.</p>