title: Use SQL to recode column value
body: <p>Questionnaire data (ordinal: 1,2,3,4 or 5) in Google BigQuery need to be fetched and aggregated using SQL syntax sum() or avg(). Before such column values aggregation can take place, some ordinal values (i.e., columns) need to be 'recoded', e.g.:</p>
  <ul>
  <li>1 to become 5</li>
  <li>2 to become 4</li>
  <li>3 to remain 3</li>
  <li>4 to become 2</li>
  <li>5 to become 1</li>
  </ul>
  <p>An example to explain the situation: the original data collection involved responding to:</p>
  <ul>
  <li>positively worded items (<em>item1</em>: &quot;I love my work.&quot;), and</li>
  <li>reversed items (<em>item2</em>: &quot;I hate my work.&quot;)
  Now both response values must be logically geared in the same 'direction' to then sum() into a new variable 'job satisfaction'; requiring <em>item2</em> to be recoded.</li>
  </ul>
  <p>How do I do that?</p>