Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

CUBRID Quizland

This CUBRID Quizland competition is over now! Thanks to all of you who were so passionate and have participated in this event.

Question 3 - Mar 07, 2011

This is a challenging question, but we will give you a hint.

Considering the “demodb” database that comes by default with the CUBRID installation:

Create a complete SQL query to find the name of the stadium where the most gold medals were ever won.

Hint: SELECT FROM stadium s, game g
WHERE s.code = g.stadium_code AND ______
GROUP BY g.stadium_code ORDER BY count(medal) DESC LIMIT 1;

You can only answer a question if you are logged in.

If you already have an account, please sign in. If not, you can always register to our website!

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: