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”
Firefoxe’s wish list…
George W. Bush’s election campaign strategy: