Jan 242014
 

I’ve not been too well recently, so to “celebrate” here’s six SQL clues to various diseases. Can you get them all? Put your answers in the comments!

select *
from   domestic_fowl
join   pimply_rash;

select * 
from   body_parts
where  description in (
   'glove filler', 
   'walking attachment', 
   'food opening'
);

select max(temperature)
from   colours
where  hue = '#FFFF00';

select *
from   people
where  sex = 'Male'
and    location in (
    select name
    from   theatre_arts_academies
    where  location = 'Russia'
);

select *
from   arcane_programming_language;

select *
from   maldive_islands
where  location = 'southern most'
and    colour = '#00FF00';

  11 Responses to “SQL Brainteasers: Guess the Disease”

  1. Hi Chris,

    my solutions:
    1) Chickenpox
    2) Hand, foot and mouth disease
    3) Yellow fever
    4) ?
    5) Mumps
    6) Giant axonal neuropathy (Gan)

    Best regards & get well soon
    Salek

  2. Nice and almost unnoticeable Spam from “domain”, but it also has a good thing. It remembered me of the really cool quizzes.
    Do you plan to post another anytime soon, Chris?

    Best regards
    Salek

    • Yes, sneaky spam there…

      Thanks for the compliments! I’ve been busy with other projects recently. I’ll have a think and see if I can cook some more up :)

 Leave a Reply

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=""> <s> <strike> <strong>

(required)

(required)