1 Table
- IMPORT INTO votes
SELECT candidate_normalized , state_postal , sum(votes) FROM precinct_results GROUP BY candidate_normalized, state_postal
Splitgraph has been acquired by EDB!
SELECT candidate_normalized
, state_postal
, sum(votes)
FROM precinct_results
GROUP BY candidate_normalized, state_postal