CREATE TABLE votes
  AS SELECT candidate_normalized
          , sum(votes) AS votes
     FROM "splitgraph/2016_election:3835145ada3f07cad99087d1b1071122d58c48783cbfe4694c101d35651fba90".precinct_results
     GROUP BY 1
     ORDER BY 2 DESC