title: add a temporary column in SQL, where the values depend from another column
body: <p>I have this table: </p>
  
  <pre><code>ID | name | result | 
  --------------------    
   1 |  A   |   1    |
  --------------------
   2 |  B   |   2    |
  --------------------
   3 |  C   |   1    |
  --------------------
   1 |  A   |   2    |
  --------------------
   4 |  E   |   2    |
  --------------------
  </code></pre>
  
  <p>I want to add a new temporary column next to |result|, and where result=1 the value should be 100, and where result=2 the value should be 80 so it should look like this:</p>
  
  <pre><code>ID | name | result | NewColumn|
  -------------------------------    
   1 |  A   |   1    |  100     |
  -------------------------------
   2 |  B   |   2    |   80     |
  -------------------------------
   3 |  C   |   1    |  100     |
  -------------------------------
   1 |  A   |   2    |  80      |
  -------------------------------
   4 |  E   |   2    |  80      |
  -------------------------------
  </code></pre>
  
  <p>How can I query this in SQL ?</p>