Tongue Twisters in SQL

I was playing round the other night can came up with this SQL to solve a popular tongue twister:

SELECT
COUNT(woodpile.is_chucked)
FROM
woodpile,
woodchuck
WHERE
woodchuck.can_chuck = 1
AND
woodpile.is_chucked = 1

Here is another one:

SELECT COUNT(pepper.picked) FROM pepper WHERE pepper.picked_by = ‘Peter Piper’

A couple more with the tongue twisters:

Which wristwatches are Swiss wristwatches?

SELECT watch.* FROM watch WHERE watch.make = ‘Swiss’

Which witch wished which wicked wish?

SELECT witch.name FROM witch WHERE witch.wish_type = ‘wicked’ AND witch.type = ‘wicked’

Who washed Washington’s white woolen underwear
when Washington’s washer woman went west?

SELECT
washer.name
FROM
washer
WHERE
washer.gender = ‘female’
AND
washer.went != ‘west’
AND
washer.washed = ‘underwear’
AND
washer.fabric = ‘wool’
AND
washer.washed_for = ‘Washington’

Poor domain name choices!

Firstly there is Who Represents?, a database for agencies to the rich and famous: http://www.whorepresents.com/

Second is the Experts Exchange, a knowledge base where programmers can exchange advice and views: http://www.expertsexchange.com

Looking for a pen? Look no further than Pen Island: http://www.penisland.net

Need a therapist? Try: http://www.therapistfinder.com

And there is an Italian Power company: http://www.powergenitalia.com

Finally we have the Mole Station Native Nursery, based in New South Wales: http://www.molestationnursery.com

(Shamelessly stolen from WebHostingTalk, but I guess was stolen from a b3ta newsletter a while ago.)