MMTU-benchmark/MMTU huggingface dataset:
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Rider            | Manufacturer   |   Laps | Time      |   Grid |
|:-----------------|:---------------|-------:|:----------|-------:|
| valentino rossi  | yamaha         |     21 | 43:06.007 |      2 |
| dani pedrosa     | honda          |     21 | +4.008    |      1 |
| andrea dovizioso | honda          |     21 | +8.536    |      6 |
| nicky hayden     | honda          |     21 | +8.858    |      4 |
| shinya nakano    | honda          |     21 | +10.583   |     15 |
| casey stoner     | ducati         |     21 | +13.640   |      7 |
| loris capirossi  | suzuki         |     21 | +15.936   |      8 |
| colin edwards    | yamaha         |     21 | +18.802   |      5 |
| chris vermeulen  | suzuki         |     21 | +23.174   |     11 |
| randy de puniet  | honda          |     21 | +25.516   |      9 |
| john hopkins     | kawasaki       |     21 | +27.609   |     10 |
| anthony west     | kawasaki       |     21 | +41.399   |     13 |
| sylvain guintoli | ducati         |     21 | +45.617   |     16 |
| alex de angelis  | honda          |     21 | +49.003   |     17 |
| toni elias       | ducati         |     21 | +59.139   |     19 |
| marco melandri   | ducati         |     21 | +1:03.328 |     14 |
| nobuatsu aoki    | suzuki         |     21 | +1:48.363 |     18 |
| jorge lorenzo    | yamaha         |     12 | accident  |      3 |
| james toseland   | yamaha         |      2 | accident  |     12 |

Question: What is the average Grid, when Rider is Shinya Nakano, and when Laps is less than 21?

table_id: 2-16287116-1
label: SELECT AVG("Grid") FROM "table" WHERE "Rider" = "shinya nakano" AND "Laps" < 21
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Rider            | Manufacturer   |   Laps | Time      |   Grid |
|:-----------------|:---------------|-------:|:----------|-------:|
| valentino rossi  | yamaha         |     21 | 43:06.007 |      2 |
| dani pedrosa     | honda          |     21 | +4.008    |      1 |
| andrea dovizioso | honda          |     21 | +8.536    |      6 |
| nicky hayden     | honda          |     21 | +8.858    |      4 |
| shinya nakano    | honda          |     21 | +10.583   |     15 |
| casey stoner     | ducati         |     21 | +13.640   |      7 |
| loris capirossi  | suzuki         |     21 | +15.936   |      8 |
| colin edwards    | yamaha         |     21 | +18.802   |      5 |
| chris vermeulen  | suzuki         |     21 | +23.174   |     11 |
| randy de puniet  | honda          |     21 | +25.516   |      9 |
| john hopkins     | kawasaki       |     21 | +27.609   |     10 |
| anthony west     | kawasaki       |     21 | +41.399   |     13 |
| sylvain guintoli | ducati         |     21 | +45.617   |     16 |
| alex de angelis  | honda          |     21 | +49.003   |     17 |
| toni elias       | ducati         |     21 | +59.139   |     19 |
| marco melandri   | ducati         |     21 | +1:03.328 |     14 |
| nobuatsu aoki    | suzuki         |     21 | +1:48.363 |     18 |
| jorge lorenzo    | yamaha         |     12 | accident  |      3 |
| james toseland   | yamaha         |      2 | accident  |     12 |

Question: What is the lowest Grid, when Laps is 21, when Manufacturer is Yamaha, and when Time is +18.802?

table_id: 2-16287116-1
label: SELECT MIN("Grid") FROM "table" WHERE "Laps" = 21 AND "Manufacturer" = "yamaha" AND "Time" = "+18.802"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Branding             | Callsign   | Frequency   | Power (kW)   | Location       |
|:---------------------|:-----------|:------------|:-------------|:---------------|
| radyo5 92.3 news fm  | dwfm       | 92.3mhz     | 25kw         | metro manila   |
| radyo5 102.3 news fm | dzyb-fm    | 102.3mhz    | 10kw         | baguio         |
| radyo5 102.3 news fm | dybc-fm    | 102.3mhz    | 5kw          | bacolod        |
| radyo5 101.9 news fm | dync-fm    | 101.9mhz    | 10kw         | cebu           |
| radyo5 101.5 news fm | dxrl-fm    | 101.5mhz    | 10kw         | cagayan de oro |
| radyo5 101.9 news fm | dxfm       | 101.9mhz    | 10kw         | davao          |

Question: What is the frequency where the power is 25kw?

table_id: 2-17822401-1
label: SELECT "Frequency" FROM "table" WHERE "Power (kW)" = "25kw"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Date       | Home team             | Score   | Away team            | Venue                           | Box Score   | Report   |
|:-----------|:----------------------|:--------|:---------------------|:--------------------------------|:------------|:---------|
| 29 october | wollongong hawks      | 101-93  | cairns taipans       | win entertainment centre        | box score   | report   |
| 30 october | new zealand breakers  | 103-99  | perth wildcats       | north shore events centre       | box score   | report   |
| 1 november | cairns taipans        | 87-89   | wollongong hawks     | cairns convention centre        | box score   | report   |
| 1 november | melbourne tigers      | 123-111 | gold coast blaze     | state netball and hockey centre | box score   | report   |
| 1 november | south dragons         | 96-87   | sydney spirit        | hisense arena                   | box score   | report   |
| 1 november | townsville crocodiles | 97-106  | new zealand breakers | townsville entertainment centre | box score   | report   |
| 2 november | adelaide 36ers        | 108-76  | sydney spirit        | distinctive homes dome          | box score   | report   |

Question: On what date were the Melbourne Tigers the home team?

table_id: 2-16653153-14
label: SELECT "Date" FROM "table" WHERE "Home team" = "melbourne tigers"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
|   Season |   Overall | Slalom   | Giant Slalom   | Super G   | Downhill   | Combined   |
|---------:|----------:|:---------|:---------------|:----------|:-----------|:-----------|
|     2003 |        42 | —        | —              | 5         | —          | —          |
|     2004 |       138 | —        | 52             | —         | —          | —          |
|     2005 |        95 | —        | —              | 31        | —          | —          |
|     2006 |        20 | —        | 16             | 4         | 34         | —          |
|     2007 |        48 | —        | 13             | 24        | —          | —          |
|     2008 |        10 | —        | 8              | 1         | 51         | —          |
|     2009 |        41 | —        | 17             | 18        | —          | —          |
|     2010 |        27 | —        | 21             | 7         | —          | —          |
|     2011 |        23 | —        | 12             | 5         | 36         | 56         |
|     2012 |         5 | —        | 5              | 8         | 4          | 20         |
|     2013 |         8 | —        | 17             | 6         | 5          | 17         |

Question: Which Slalom has a Downhill of 4?

table_id: 2-14553797-1
label: SELECT "Slalom" FROM "table" WHERE "Downhill" = "4"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Date         | Pos.   | Player            | From club        | Transfer fee   |
|:-------------|:-------|:------------------|:-----------------|:---------------|
| 13 july 2007 | fw     | rolando bianchi   | reggina          | £8.8m          |
| 14 july 2007 | mf     | gelson fernandes  | fc sion          | undisc.        |
| 17 july 2007 | mf     | geovanni          | cruzeiro         | free           |
| 26 july 2007 | mf     | martin petrov     | atlético madrid  | £4.7m          |
| 2 aug. 2007  | df     | vedran ćorluka    | dinamo zagreb    | undisc.        |
| 2 aug. 2007  | mf     | elano             | shakhtar donetsk | £8m            |
| 2 aug. 2007  | df     | javier garrido    | real sociedad    | £1.5m          |
| 3 aug. 2007  | fw     | valeri bojinov    | fiorentina       | £5.75m         |
| 31 jan. 2008 | fw     | felipe caicedo    | fc basel         | £5.2m          |
| 31 jan. 2008 | fw     | benjani mwaruwari | portsmouth       | £3.87m         |

Question: Which Player has a Date of 13 july 2007?

table_id: 2-14986996-14
label: SELECT "Player" FROM "table" WHERE "Date" = "13 july 2007"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Nation        |   Gold |   Silver |   Bronze |   Total |
|:--------------|-------:|---------:|---------:|--------:|
| united states |      8 |        6 |        3 |      17 |
| argentina     |      4 |        5 |        3 |      12 |
| brazil        |      2 |        2 |        2 |       6 |
| mexico        |      0 |        1 |        5 |       6 |
| cuba          |      0 |        0 |        1 |       1 |

Question: What is the least silver that has mexico as a nation and a gold less than 0?

table_id: 2-12379470-3
label: SELECT MIN("Silver") FROM "table" WHERE "Nation" = "mexico" AND "Gold" < 0
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Place   | Player         | Country       | Score        | To par   |
|:--------|:---------------|:--------------|:-------------|:---------|
| 1       | ricky barnes   | united states | 67-65-70=202 | –8       |
| 2       | lucas glover   | united states | 69-64-70=203 | –7       |
| t3      | david duval    | united states | 67-70-70=207 | –3       |
| t3      | ross fisher    | england       | 70-68-69=207 | –3       |
| t5      | hunter mahan   | united states | 72-68-68=208 | –2       |
| t5      | phil mickelson | united states | 69-70-69=208 | –2       |
| t5      | mike weir      | canada        | 64-70-74=208 | –2       |
| t8      | retief goosen  | south africa  | 73-68-68=209 | –1       |
| t8      | todd hamilton  | united states | 67-71-71=209 | –1       |
| t8      | sean o'hair    | united states | 69-69-71=209 | –1       |
| t8      | bubba watson   | united states | 72-70-67=209 | –1       |

Question: What is the place of the player with a 72-70-67=209 score?

table_id: 2-18811891-6
label: SELECT "Place" FROM "table" WHERE "Score" = "72-70-67=209"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Call Sign   | City of License          | Frequency   | age Watt             | Coverage Area            | Founded        |
|:------------|:-------------------------|:------------|:---------------------|:-------------------------|:---------------|
| wvmr        | frost, west virginia     | 1370 khz    | 5,000 watts day only | pocahontas county        | june 1981      |
| wvls        | monterey, virginia       | 89.7 mhz    | 360 watts            | highland county          | may 1995       |
| wchg        | hot springs, virginia    | 107.1 mhz   | 160 watts            | bath county              | june 1995      |
| w278al      | durbin, west virginia    | 103.5 mhz   | 50 watts             | durbin / bartow          | july 1998      |
| wvmr-fm     | hillsboro, west virginia | 91.9 mhz    | 550 watts            | hillsboro                | october 2010   |
| wnmp        | marlinton, west virginia | 88.5 mhz    | 1,000 watts          | marlinton / huntersville | september 2011 |

Question: Name the city of license which has age Watt of 160 watts

table_id: 2-12525402-1
label: SELECT "City of License" FROM "table" WHERE "age Watt" = "160 watts"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Position   | Gymnast                    |   A Score |   B Score |   Total |
|:-----------|:---------------------------|----------:|----------:|--------:|
| 1st        | diego hypólito ( bra )     |       6.6 |     9.35  |  15.95  |
| 2nd        | marian drăgulescu ( rou )  |       6.9 |     9.025 |  15.925 |
| 3rd        | gervasio deferr ( esp )    |       6.5 |     9.325 |  15.825 |
| 4th        | fabian hambuechen ( ger )  |       6.5 |     9.3   |  15.8   |
| 5th        | kōhei uchimura ( jpn )     |       6.5 |     9.225 |  15.725 |
| 6th        | zou kai ( chn )            |       6.7 |     9.1   |  15.7   |
| 7th        | anton golotsutskov ( rus ) |       6.5 |     9.1   |  15.6   |
| 8th        | alexandr shatilov ( isr )  |       6.6 |     9     |  15.6   |

Question: what is the sum of the b score when the a score is 6.6 and the total is 15.6?

table_id: 2-18662017-2
label: SELECT SUM("B Score") FROM "table" WHERE "A Score" = 6.6 AND "Total" = 15.6
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Home team       | Home team score   | Away team       | Away team score   | Venue                 |   Crowd | Date        |
|:----------------|:------------------|:----------------|:------------------|:----------------------|--------:|:------------|
| geelong         | 15.21 (111)       | hawthorn        | 3.9 (27)          | corio oval            |    9500 | 4 june 1928 |
| footscray       | 18.15 (123)       | north melbourne | 8.13 (61)         | western oval          |   17000 | 4 june 1928 |
| fitzroy         | 17.13 (115)       | richmond        | 19.6 (120)        | brunswick street oval |   15000 | 4 june 1928 |
| essendon        | 10.7 (67)         | st kilda        | 11.10 (76)        | windy hill            |   20000 | 4 june 1928 |
| south melbourne | 9.14 (68)         | collingwood     | 13.7 (85)         | lake oval             |   22000 | 4 june 1928 |
| melbourne       | 10.14 (74)        | carlton         | 9.10 (64)         | mcg                   |   41402 | 4 june 1928 |

Question: What is Melbourne's home venue?

table_id: 2-10766119-8
label: SELECT "Venue" FROM "table" WHERE "Home team" = "melbourne"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Name                   | Country   | Role       | Period                          | Teams                                            |
|:-----------------------|:----------|:-----------|:--------------------------------|:-------------------------------------------------|
| radhouane abbes        | algeria   | defender   | 1987-1988 & 1989-1990           | montpellier hsc                                  |
| djamel abdoun          | algeria   | midfielder | 2003-2006 2008-2009             | ac ajaccio fc nantes                             |
| boumediene abderahmane | algeria   | defender   | 1945-1949 & 1953-1954 1949-1952 | fc sète olympique de marseille                   |
| madjid adjaoud         | algeria   | midfielder | 1999-2003                       | cs sedan                                         |
| nassim akrour          | algeria   | forward    | 2002-2003 2008-2010             | troyes ac grenoble foot                          |
| ridha ali messaoud     | algeria   | forward    | 1976-1977                       | paris sg                                         |
| said amara             | algeria   | midfielder | 1956-1957 1957-1958 1962-1964   | rc strasbourg béziers girondins de bordeaux      |
| salim arrache          | algeria   | midfielder | 2003-2006 2006-2008 2008        | rc strasbourg olympique de marseille toulouse fc |

Question: Which period has the team CS Sedan?

table_id: 2-17546250-2
label: SELECT "Period" FROM "table" WHERE "Teams" = "cs sedan"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Constituency number   | Name      | Reserved for ( SC / ST /None)   | District   |   Number of electorates (2009) |
|:----------------------|:----------|:--------------------------------|:-----------|-------------------------------:|
| 1                     | sheopur   | none                            | sheopur    |                         169230 |
| 2                     | vijaypur  | none                            | sheopur    |                         158561 |
| 3                     | sabalgarh | none                            | morena     |                         155076 |
| 4                     | joura     | none                            | morena     |                         173767 |
| 5                     | sumawali  | none                            | morena     |                         175095 |
| 6                     | morena    | none                            | morena     |                         183064 |
| 7                     | dimani    | none                            | morena     |                         159715 |
| 8                     | ambah     | sc                              | morena     |                         166343 |
| total:                | total:    | total:                          | total:     |                        1340851 |

Question: Which Name has a Reserved for of none, and a Constituency number of 7?

table_id: 2-18495923-1
label: SELECT "Name" FROM "table" WHERE "Reserved for ( SC / ST /None)" = "none" AND "Constituency number" = "7"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| District    | Incumbent            | Party      |   First elected | Result                                          | Candidates                                       |
|:------------|:---------------------|:-----------|----------------:|:------------------------------------------------|:-------------------------------------------------|
| tennessee 4 | joe l. evins         | democratic |            1946 | re-elected                                      | joe l. evins (d) unopposed                       |
| tennessee 5 | percy priest         | democratic |            1940 | re-elected                                      | percy priest (d) 90.8% robert m. donihi (r) 9.2% |
| tennessee 6 | james patrick sutton | democratic |            1948 | retired to run for u. s. senate democratic hold | ross bass (d) 99.4% lon brewer (r) 0.6%          |
| tennessee 7 | tom j. murray        | democratic |            1942 | re-elected                                      | tom j. murray (d) unopposed                      |
| tennessee 8 | jere cooper          | democratic |            1928 | re-elected                                      | jere cooper (d) unopposed                        |

Question: What district is tom j. murray from?

table_id: 1-1342013-41
label: SELECT "District" FROM "table" WHERE "Incumbent" = "Tom J. Murray"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
|   Round | Circuit                       | Date         | Pole Position      | Fastest Lap        | Winning Driver     | Winning Team      |
|--------:|:------------------------------|:-------------|:-------------------|:-------------------|:-------------------|:------------------|
|       1 | autodromo nazionale monza     | 30 march     | eric salignon      | josé maría lópez   | augusto farfus     | rc motorsport     |
|       2 | masaryk circuit , brno        | 14 april     | ronnie quintarelli | ronnie quintarelli | augusto farfus     | rc motorsport     |
|       3 | circuit de nevers magny-cours | 29 april     | julien pressac     | ryan briscoe       | bruno spengler     | graff racing      |
|       4 | silverstone circuit           | 5 may        | augusto farfus     | augusto farfus     | augusto farfus     | rc motorsport     |
|       5 | circuit zolder                | 18 may       | augusto farfus     | ronnie quintarelli | ronnie quintarelli | cram competition  |
|       6 | hungaroring                   | 29 july      | augusto farfus     | césar campaniço    | augusto farfus     | rc motorsport     |
|       7 | a1 ring , spielberg           | 24 august    | robert kubica      | eric salignon      | eric salignon      | graff racing      |
|       8 | nürburgring                   | 8 september  | josé maría lópez   | marc benz          | marc benz          | jenzer motorsport |
|       9 | circuito del jarama , madrid  | 28 september | césar campaniço    | césar campaniço    | ryan briscoe       | prema powerteam   |

Question: Where was the circuit for round 4?

table_id: 1-25213146-2
label: SELECT "Circuit" FROM "table" WHERE "Round" = 4
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Celebrity        | Famous for                                        | Entered   | Exited   | Finished   |
|:-----------------|:--------------------------------------------------|:----------|:---------|:-----------|
| matt willis      | ex busted member and tv presenter                 | day 1     | day 19   | 1st        |
| myleene klass    | tv presenter, singer, model                       | day 1     | day 19   | 2nd        |
| jason donovan    | australian actor, singer                          | day 1     | day 19   | 3rd        |
| david gest       | american tv producer                              | day 1     | day 18   | 4th        |
| dean gaffney     | actor (played robbie jackson in eastenders )      | day 5     | day 18   | 5th        |
| jan leeming      | newsreader                                        | day 1     | day 17   | 6th        |
| malandra burrows | actress (played kathy glover in emmerdale )       | day 6     | day 16   | 7th        |
| phina oruche     | actress                                           | day 1     | day 15   | 8th        |
| lauren booth     | model, journalist, younger sister of cherie booth | day 1     | day 14   | 9th        |
| faith brown      | impressionist, comedian                           | day 1     | day 13   | 10th       |
| scott henshall   | fashion model, designer                           | day 1     | day 12   | 11th       |
| toby anstis      | radio host                                        | day 1     | day 11   | 12th       |

Question: Which celebrity who was famous for being the ex busted member and TV presenter exited on day 19?

table_id: 2-14345690-7
label: SELECT "Celebrity" FROM "table" WHERE "Exited" = "day 19" AND "Famous for" = "ex busted member and tv presenter"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Name                                           | Appointed/Elected   | Term expires      | Appointing Governor   | Governor's Party Affiliation   |
|:-----------------------------------------------|:--------------------|:------------------|:----------------------|:-------------------------------|
| chief justice mark cady                        | 1998                | december 31, 2016 | terry branstad        | republican                     |
| david wiggins                                  | 2003                | december 31, 2020 | tom vilsack           | democratic                     |
| daryl hecht                                    | 2006                | december 31, 2016 | tom vilsack           | democratic                     |
| brent r. appel                                 | 2006                | december 31, 2016 | tom vilsack           | democratic                     |
| bruce b. zager                                 | february 2011       | december 31, 2020 | terry branstad        | republican                     |
| edward mansfield category:articles with hcards | february 2011       | december 31, 2020 | terry branstad        | republican                     |
| thomas d. waterman                             | february 2011       | december 31, 2020 | terry branstad        | republican                     |

Question: What is the party affiliation of Thomas D. Waterman, whose appointing governor is Terry Branstad?

table_id: 2-1189288-1
label: SELECT "Governor''s Party Affiliation" FROM "table" WHERE "Appointing Governor" = "terry branstad" AND "Name" = "thomas d. waterman"
Task: NL2SQL (source dataset: WikiSQL)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Table:
| Episode                        | Air Date       | Timeslot   |   Rating |   Share | 18-49      | Viewers   | Weekly Rank   |
|:-------------------------------|:---------------|:-----------|---------:|--------:|:-----------|:----------|:--------------|
| "goodbye city...hello country" | april 30, 2008 | 9:00 p.m.  |      1.7 |       3 | 1.0/3 (#5) | 2.37 (#5) | 89/96         |
| "pigs & cows & sheeps...oh my" | may 7, 2008    | 9:00 p.m.  |      1.5 |       2 | 1.0/3 (#5) | 2.11 (#5) | 90/97         |
| "wet 'n wild"                  | may 14, 2008   | 9:00 p.m.  |      1.3 |       2 | 0.9/2 (#5) | 1.96 (#5) | 90/96         |
| "do-si-do"                     | may 28, 2008   | 9:00 p.m.  |      1.8 |       3 | 0.9/2 (#5) | 2.44 (#5) | 75/87         |
| "as country as apple pie"      | june 4, 2008   | 9:00 p.m.  |      1.3 |       2 | 0.8/2 (#5) | 2.01 (#5) | 79/91         |
| "it's show time"               | june 11, 2008  | 9:00 p.m.  |      1.3 |       2 | 0.8/2 (#5) | 2.04 (#5) | 76/88         |
| "a family affair"              | june 18, 2008  | 9:00 p.m.  |      1.5 |       3 | 0.8/2 (#5) | 2.00 (#5) | tba           |
| "farmer picks a wife"          | june 25, 2008  | 9:00 p.m.  |      1.6 |       3 | 1.0/3 (#5) | 2.45 (#5) | tba           |

Question: What is Viewers, when Episode is "A Family Affair"?

table_id: 2-16225725-4
label: SELECT "Viewers" FROM "table" WHERE "Episode" = """a family affair"""