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