Suspected electoral fraud in Glasgow probed

[xoggoth]

Good post.

I would like to see politics and government in their entirety replaced by computer programs. It would not be very expensive, I'm sure the old ZX81 I have somewhere in my attic could do a fair job or replacing the Labour Party.

[EternalOptimist]

'delete dole from user where count(user_id) >1 and hair_colour = D93E14'

[BrilloPad]

Find 10 pieces of paper out of how many?!?!?

BBC News - Scottish referendum: Suspected electoral fraud in Glasgow probed

Here's my solution:

select id, count(*) from voters group by id having count(*) > 1;

select count(1) as result from voters which vote_cast = 'Y'

ScooterScot

[kingcook]

Find 10 pieces of paper out of how many?!?!?

BBC News - Scottish referendum: Suspected electoral fraud in Glasgow probed

Here's my solution:

select id, count(*) from voters group by id having count(*) > 1;