Feb 242015
 

The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;)

With this in mind here’s a some of the facts and figures from 2014’s database design quizzes, along with related trivia:

-- How many player were there in total?
select count(*)
from   players;

COUNT(*)
--------
     533

-- The same number of calories as a 
-- Five Guys BLT

-- How many people took every quiz?
select count(*)
from   players
where  quizzes_taken = 52;

COUNT(*)
--------
      33

-- The ascii character code for 
-- the exclamation mark!

-- What was the total of all scores 
-- across all players?
select sum(scores)
from   players;

SUM(SCORES)
-----------
    2922577

-- About the same mass in kg as a 
-- Saturn V Rocket (2,970,000 kg)

-- and how long did they take 
-- to place their answers?
select sum(user_seconds)
from   player_answers;


SUM(USER_SECONDS)
-----------------
          3518872

-- 40 days, 17 hours, 27 minutes and 52 seconds
-- About 0.46 years on the planet of Mercury

Want to know what all the fuss is about? Then just head over to PL/SQL Challenge and sign up for a free account. Who knows, it could be your name in lights this time next year ;)

Nov 012013
 
set sqlterminator ?

select queries
from   your_database?

QUERIES
----------------
Become questions

set sqlterminator !

select queries
from   the_database!

QUERIES
--------------------
Become exclamations!

You need to run in SQL*Plus to use this. I can’t think of a particularly good use – other than playing tricks on your colleagues! ;)