sqlite> select precinct, round7, count(*) from ballots where contest='Mayor' and district=6 and round7 not in ('exhausted', 'undervote', 'overvote') group by precinct, round7;
precinct | round7 | count(*) |
---|---|---|
Pct 7601 | Jane Kim | 90 |
Pct 7601 | London Breed | 101 |
Pct 7601 | Mark Leno | 92 |
Pct 7602 | Jane Kim | 125 |
Pct 7602 | London Breed | 119 |
Pct 7602 | Mark Leno | 119 |