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