Followed a tweet by Alex Popescu and wound up here:
CUBRID it! is an online programming contest which requires finding and coding the best solution for a SQL related problem we will be proposing.
This programming contest is organized by the CUBRID Open Source community once every year.
This year the contest will be held between June 1st and June 22nd.
CUBRID it! is open to all talented developers who are willing to challenge their skills and compare themselves to other passionate developers from all around the world.
In the end, it’s all about coding and having fun, together with other CUBRID fans!
See the website for the full details but the problem:
Given all the tables in a database (but only the user tables, not also the system tables), determine:
- The value which occurs the most times (is duplicated the most times) in the database and it is “non-numeric”! (“non-numeric” means that the respective value does not contain only digits – it must contain at least one non-digit character; for example, “1298” is “numeric”, but “12,98” is “non-numeric” ( and also “12.98” ), because it contains the “,” character ; same goes for “-100” – it is considered “non-numeric” as well, because of the “-” sign).
- The number of occurrences for the value found above.
just sounds like a topic map problem doesn’t it?