title: Question about multiplying columns in SQL
body: <p>I was wondering if it was possible to multiply two columns and if so how would this take place</p>
  
  <p>Suppose I have a table</p>
  
  <pre><code>a    b
  1    4
  2    5
  3    6
  </code></pre>
  
  <p>Could I do something like</p>
  
  <pre><code>SELECT a *b from table
  </code></pre>
  
  <p>Would this multiply the contents row by row then store it in a new column</p>
  
  <p>Are these result right</p>
  
  <pre><code>4
  10
  18
  </code></pre>