Dec 312014
 

Another batch of SQL brainteasers. This time the clues are to the powers of mythical creatures – the task is to guess the creature!

There’s six in all, can you get them all? Put your answers in the comments!

update target_of_gaze
set    state = 'stone';

begin
  delete from creature
  where  appendage = 'head';

  insert into creature (appendage)
  values ('head');

  insert into creature (appendage)
  values ('head');
end;
/

update bird
set    state = 'alive'
where  state = 'burning';

select *
from   women
where  singing = 'deadly';

update creature
set    body = 'furry'
where  moon = 'full';

select *
from   men
where  powers in (
  'conferring playthings',
  'determining moral terpitude'
);

  4 Responses to “SQL Brainteasers: Guess the Mythical Creature”

  1. Happy 2015 from my time zone!

    SELECT
    ‘Medusa,
    Hydra,
    Phoenix,
    Sirens,
    Werewolf,
    (too lazy to look up “terpitude” at this time of day)’ AS “my guess”
    FROM DUAL;

  2. The last looks like Santa Claus :-)

    Happy New Year!

 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)