copy
  (select *, (C1 + C2 + C3 + C4 + C5) as sum
  from csv)
  to 'junk.csv';