Dec 162013

Christmas is approaching, so some Christmassy-themed songs to guess. Seven to get this time (because it’s Chrismtas ;). As always, put your answers in the comments!

select *
from   men
where  name like 'Christmas song'
and    rownum = 1;

select min(size)
from   equus_africanus_asinus;

sqlplus -s darkness

select *
from   days
where  extract(day from dy) = 25
and    extract(month from mn) = 12
and    colour = '#FFFFFF';

select *
from   plants
where  name in (select name
                from   girls_names);

select name
from   men
where  composition = 'frozen rain';

  while (sheep_tenders = observant)
  end loop;

Note – the fourth one was updated from #000000 to #FFFFFF following comments from Salek.

  8 Responses to “SQL Brainteasers: Guess the Christmas Carol/Song”

  1. 1) “Santa Claus Is Coming to Town” (?)
    2) “Little Donkey”
    3) “Silent Night”
    5) “The Holly and the Ivy”
    6) “Frosty the Snowman”
    7) “While Shepherds Watched Their Flocks”

    4) Guesses:
    “O Holy Night”
    “It Came Upon the Midnight Clear”
    (because of the “#000000”, is this really correct or should it be “#FFFFFF”?)

    Not easy this time…

  2. #1 Looks like “The First Noel”.. however, it should have an ORDER BY somewhere ;)

  3. 1. Oh Come, Oh Come, Emanuel – I chose this because it’s the first Christmas song ever written.
    2. Dominick the Donkey – Becususe equus_africanus_asinus is a donkey.
    3. Christmas Time (Don’t Let the Bells End), The Darkness – A Christmas song by The Darkness.
    4. White Christmas – It’s Christmas Day and it’s white #FFFFFF
    5. A Christmas Rose – Rose is a plant and it’s also a girl’s name.
    6. Frosty the Snowman – A Christmas Song about a man composed of frozen precipitation
    7. While Shepherds Watched – These must have been some observant sheep tenders.

    • Thanks for your answers Steve, Merry Christmas!

      If you look further up in the comments you’ll see the answers I intended. “A Christmas Rose” fits very well for 5 too. I wasn’t aware “Oh come, o come Emannual was the first Christmas song!

 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>