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 ;)

  2 Responses to “The Database Design Quiz in Numbers: 2014 Review”

  1. Hello Chris,
    Thanks a lot again for your tremendous work along the whole year and also for the Playoff :):)

    And, thanks a lot as well for your patience to read and answer our comments and not few objections :):)

    All in all, it is a very educative quiz, addiction already ensured :)

    Best Regards & Keep up with the excellent work !
    Iudith

    • Glad to hear you’ve got the addiction ;)

      The comments and objections reassure me that people care :) I get worried if too long goes by without any comments…

 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)