Skip to content

Instantly share code, notes, and snippets.

@allenwlee
Created April 16, 2013 23:32
Show Gist options
  • Save allenwlee/5400551 to your computer and use it in GitHub Desktop.
Save allenwlee/5400551 to your computer and use it in GitHub Desktop.

select voters.last_name, voters.first_name, congress_members.name, count() from voters, votes, congress_members where voters.id = votes.voter_id and congress_members.id = votes.politician_id group by politician_id having count() > 1 order by voters.first_name;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment