SQL Contest
The SQL Contest is a competition that takes place at the most important national event in the Database field, the Brazilian Symposium on Databases (SBBD). It is inspired by the programming marathon of the Brazilian Computer Society. The SQL Marathon is intended for high school technical students, undergraduates, and IT professionals.
The competition requires participants to demonstrate creativity, teamwork, the pursuit of new solutions, and the ability to solve problems under pressure. During the event, problems will be provided along with a database schema and its instance. Solutions must be submitted as queries using the SQL language. They will be evaluated based on their correctness and the number of submissions made.
Each team can consist of up to three members, and the team composition can be as follows:
High School Level:
- 2 high school students + 1 undergraduate student, or
- 3 high school students
Higher Education Level:
- 2 undergraduate students + 1 postgraduate student, or
- 2 undergraduate students + 1 professional, or
- 3 undergraduate students
Teams are allowed to use only one computer to solve up to six problems in 2.5 hours. Each team is responsible for bringing its own computer. Remember that computers can fail; therefore, it is advisable to have a backup device.
Teams may use printed books, articles, or manuals. The database management system used during the marathon will be PostgreSQL, so familiarity with its SQL syntax is required.
Teams will be ranked based on the number of problems solved, with the tiebreaker being the fewest number of submissions. There will be two winning teams: one for high school and one for undergraduates. The winning teams in each category (high school and undergraduate) will be those that solve the highest number of problems in the least amount of total time.