Objective

You will be given a set of tables covering a specific topic (e.g., Education or Banking) with one of the tables or columns highlighted (e.g., Location). Your task is to write two different non-trivial SQL queries and related questions. The central focus of queries and questions should be highlighted table or column.

You can download the instructions in PDF format here.

Example

Documentary

DocumentaryIDTitleContextDirectorID
(→ Director.DirectorID)
1Apollo 11Space Race Era5
2Blue Planet IIAnthropocene4
3Planet EarthHolocene3
4Wild AfricaHolocene2
5The Hunt for Bin LadenWar on Terror Era1

Director

DirectorIDFirstNameLastNameBirthYearDeathYear
1ChristopherNolan1970None
2FrankDarabont1959None
3QuentinTarantino1963None
4ChristopherMcQuarrie1967None
5RobertZemeckis1945None



Example of a completed annotation for highlighted column Context:

Interface

Requirements

  1. SQL queries must have a highlighted column or a main column in a highlighted table as one of the output columns.  
  2. SQL queries should not contain WHERE clauses with a highlighted column or table.  
  3. If your database consists of multiple related tables, you should use the JOIN operator in your SQL query whenever possible.  
  4. The question should reflect your SQL query, but be simple and clear.  
  5. 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/...")