Mar 212014
 

Back on the films today, here’s another six to get:

select talk
from   monarch;

select * 
from   (select city_name
        from   cities
        where  state = 'IL'
        order  by population desc)
where  rownum = 1;

select * 
from   nations
where  not exists (
         select null
         from   people
         where  status = 'retired'
         and    sex = 'male'
         and    p.location = n.location
);

sqlplus -s young_ovis_aries

select key
from   injury;

select *
from   human_property
where  duration between date '2000-01-01'
                and date '2012-12-31';

Finally, there’s something that links all the above films. Can you get it?

Put your answers in the comments!

Feb 212014
 

Back on the film quizzes this time with a mathematical twist for the clues:

select count(*) 
from   days_of_the_week;

select * 
from   cerebrum
where  power(e, i * pi) + 1 = 0;

select * 
from   direction_finder
where  length = (1 + sqrt(5)) / 2;

select * 
from   shape
where  height = width
and    width = depth;

select *
from   frankensteins_possesions
where  (x * x) + (y * y) + (z * z) = (r * r);

select *
from   unknown_people
where  E = m * c * c;

Can you guess all six? Put your answers in the comments!

Nov 292013
 

As always, when you think you’ve got answers, put them in the comments.

exec dbms_output.put_line(chr(69) || chr(84));

select cephalopod 
from   molluscs
where  form like 'cat';

insert into visage
values ('flesh wound');

with affection as (
  select *
  from   soviet_nation
)
  select * from affection;

create sequence response;

select *
from   vehicles
where  type in (
  'flying vessels', 
  'locomotives', 
  'mechanised chariots'
);
Nov 082013
 

Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!

select english_bard
from   people
where  status = 'Enamoured';

with zohan as (
  select *
  from   you
  where  state <> 'Tidy'
)
  select * from zohan;

select boron
from   periodic_table;

select *
from   day
where  time between 'sunset' and 'sunrise';

set role fashion_displayers;

begin
  lock table inventory in exclusive mode;
  
  select count(*)
  into   vapour
  from   inventory 
  where  type = 'Cylindrical container'
  having count(*) = 2;
end;
/
Oct 252013
 

These are proving popular, so here’s another six clues to films. If you’d like to catch up on the previous ones, have a look at the quizzes tag. As always, put your answers in the comments!

select *
from   parents
where  sex = 'male'
and    status = 'divine';

select male_cerebrum
from   dual;

delete apparitions
where  status = 'dead';

select large_cost
from   offspring;

select soldiers
from   squad;

select count(*) over 
           (partition by home_of_cuculidae)
from   flights
where  rownum = 1;
Oct 182013
 

Finishing up the week, we’re back onto films again, I hope you enjoyed this week’s quizzes. If you missed any, then take a look at the TV shows, albums, books and computer games. As always, put your answers in the comments.

select day
from   dates
where  extract(day from date) = 4
and    extract(month from date) = 7;

select thieves
from   seafarers
where  location between 
          'North America' and 'South America';

select *
from   people
where  sex = 'female'
and    atomic_number = 26;
Oct 112013
 

As before, if you can guess the film titles from these SQL clues then put your answers in the comments. If you’ve missed the earlier quizzes, have a look at parts one, two and three.

select * 
from   mandibles;

select *
from   pedites
where  side <> 'right';

select *
from   nuptials
where  rownum <= 4
union
select *
from   burial
where  rownum = 1;

select existence
from   numbers
where  value = circumference/diameter;

create procedure africa (
  karen out varchar2
) as
begin
  null;
end;

create table armoured_soldiers as
  select x, y
  from   points
  where  ((x-a)*(x-a)) + ((y-b)*(y-b)) = r*r;
Sep 272013
 

Can you get these films from the SQL clues below? Put your answers in the comments! If you want more, have a look at the first and second in this series.

begin
  private_ryan;
  commit;
end;
/

select colour
from   kilometers
where  distance = 1.6
and    shade between 'blue' and 'yellow';

select *
from   the_unhappy
where  nationality = 'French';

select *
from   back as of timestamp sysdate + 1;

select top 1 *
from   ballistic_weapons;

select common_surname
from   states
where  capital = 'Indianapolis'
and    military_expedition = 'final';
Sep 202013
 

Continuing the SQL brainteasers (back to the first), can you figure these next six film titles from the SQL clues? Put your answers in the comments!

select greenbacks
from   clenched_hands;

select *
from   sodium
natural join chlorine;

alter session set nls_territory = Italy;
exec dbms_job.run(:job);

begin
  execute immediate 
    'begin mimus_polyglottos; end;';
end;

select direction
from   compass
where  degrees = 337.5;

select danger
from   transactions
where  isolation_level < 'serializable';
Sep 132013
 

Can you guess the name of the film from these code snippets? Put your answers in the comments!

begin
  return skywalker;
end;

exec dbms_lock.sleep(:gorgeous);

select count(*)
from   primates 
having count(*) = 12;

select annoying_habits
from   you
where  rownum <= 10;

select * 
from   mission
where  1 = 2;

select power(motor_company, 1)
from   man
where  address = 'the world'
and    status = 'secret';