Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Seat,Name,Party, COUNT(Vote_Serial) as 'Total Votes'
- FROM rpVot_Votes
- JOIN rpVot_Candidates ON
- rpVot_Candidates.ID = rpVot_Votes.CandidateID
- GROUP by Seat, Party
- ORDER BY Seat, COUNT(*) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement