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
SQL
-
SELECT fName, lName, street, city, state, zip, country
-
FROM people
-
WHERE STATUS = ‘nice’
-
AND age < 18
-
ORDER BY country DESC;
Santa’s Coal List
SQL
-
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
SQL
-
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
SQL
-
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.
December 14th, 2005 at 9:29 pm
Firefoxe’s wish list…
December 15th, 2005 at 8:32 am
George W. Bush’s election campaign strategy: