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 thoughts on “Holiday SQL

Leave a Reply

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

Connect with Facebook

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>