Categories
Funny Programming

Holiday SQL

You’ve got to be somewhat nerdy for this, but if your reading this, you automatically qualify. Perhaps I’ll add to this list when I’m bored. If I have the time. If someone is so inclined, feel free to do so below.

Santa’s Present List

SELECT fName, lName, street, city, state, zip, country
FROM people
WHERE STATUS = ‘nice’
AND age < 18
ORDER BY country DESC;

Santa’s Coal List

SELECT fName, lName, street, city, state, zip, country
FROM people
WHERE STATUS = ‘naughty’
AND age < 18
ORDER BY country DESC;

Santa’s Personal Wish List

SELECT fName, lName, street, city, state, zip, country
FROM people
WHERE STATUS = ‘naughty’
AND age BETWEEN 18 AND 25
AND height BETWEEN 67 AND 72
AND cupSize > ‘C’
AND sex = ‘female’
ORDER BY age ASC;

Paris Hilton’s Personal Wish List

SELECT fName, lName, street, city, state, zip, country
FROM people
WHERE age BETWEEN 18 AND 30;

Feel free to give it a try if your geeky enough to do so. I’ll update them to color syntax.

2 replies on “Holiday SQL”

Leave a Reply

Your email address will not be published. Required fields are marked *