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 *