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.

Tags: , ,

Related Posts

Related Posts


2 Responses to “Holiday SQL”

  1. Daruku says:

    Firefoxe’s wish list…

    SELECT *
    FROM users
    WHERE browser LIKE ‘IE%’
  2. Neil T. says:

    George W. Bush’s election campaign strategy:

    SELECT firstname, lastname, address
    FROM voters
    WHERE iq

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

By submitting a comment here you grant this site a perpetual license to reproduce your words and name/web site in attribution.