Documentary
| DocumentaryID | Title | Context | DirectorID |
| | | (→ Director.DirectorID) |
| 1 | Apollo 11 | Space Race Era | 5 |
| 2 | Blue Planet II | Anthropocene | 4 |
| 3 | Planet Earth | Holocene | 3 |
| 4 | Wild Africa | Holocene | 2 |
| 5 | The Hunt for Bin Laden | War on Terror Era | 1 |
Director
| DirectorID | FirstName | LastName | BirthYear | DeathYear |
| 1 | Christopher | Nolan | 1970 | None |
| 2 | Frank | Darabont | 1959 | None |
| 3 | Quentin | Tarantino | 1963 | None |
| 4 | Christopher | McQuarrie | 1967 | None |
| 5 | Robert | Zemeckis | 1945 | None |
Example of a completed annotation for highlighted column Context:
Requirements
- SQL queries must have a highlighted column or a main column in a highlighted table as one of the output columns.
- SQL queries should not contain WHERE clauses with a highlighted column or table.
- If your database consists of multiple related tables, you should use the JOIN operator in your SQL query whenever possible.
- The question should reflect your SQL query, but be simple and clear.
- You can also write a question in the form of an instruction or command (as you would ask an assistant, e.g. "Show me/Provide/...")