The "first past the post election" query problem
- by MPelletier
This problem may seem like school work, but it isn't. At best it is self-imposed school work. I encourage any teachers to take is as an example if they wish.
"First past the post" elections are single-round, meaning that whoever gets the most votes win, no second rounds.
Suppose a table for an election.
CREATE TABLE ElectionResults (
…