The source code of your movie player (i206.pas, i206.cpp, ...), an animation (i206film.dat, i206film.txt, ...) created by you and a short documentation (i206.txt, i206.pdf, ...) should be submitted, also describing briefly how to create a movie and specifying the name of the developer environment to use.

You should create queries to solve the following problems. Try to implement each task by using a single SQL query (or an equivalent reformulation).

3. Determine the date when the Hungarian team won with the biggest difference in scores. Create a query to get the date, the name of the opponent and the result. If there is more than one answer, you can give any or all of them. (3winning)

4. Create a query to determine how many times the Hungarian team won in consecutive years. (4years)

5. Create a query to list when a given opponent was first defeated by the Hungarian team. (5first)

6. Create a query to list those opponents that were never defeated by the Hungarian team. Each opponent should be listed only once. (6notwon)

7. As for football, Austria was the most common opponent for Hungary. Is the situation similar in ice hockey? Make a query to list those opponents that were more common opponents than Austria. (7austria)

8. Create a single query to determine the number of matches in which the Hungarian team won, achieved a draw or lose. (8stat)

9. Create a query to list the matches played against Romania in chronological order. The first column is the number of the match, the next column is the date, then the city follows, then points scored by the Hungarian team, finally, points scored by the opponent are listed. (9romania)

The following example shows the first few lines of query 9romania.

The database (i207.odb, i207.mdb) or a text document (i207.txt, i207.pdf, ...) should be submitted, containing the creation of the table and SQL codes of the queries (arranged neatly), together with a short documentation (i207dok.txt, i207dok.pdf, ...), also describing the name and version number of the database application.